Hmm. Interesting idea. I just may give that a try. Kind of solved it just doing some variable checking.
Jan ----- Original Message ----- From: "Walker, Buddy" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, November 12, 2004 7:53 AM Subject: [RBG7-L] - RE: Adding tables to form Jan I had the same problem. This is what I did. To give you some insight. I have a number of tables with SSN, StartDate and EndDate common Columns. I then created a tab form with all my tables as tabs, but because I had StartDate and EndDate in my driving table as well as other tables with different dates nothing would show. So what I did was create a temporary view/table with only one column the SSN as my driving table. Since all the linking comes from the driving table no problem. Hope this helps Buddy -----Original Message----- From: Jan Johansen [mailto:[EMAIL PROTECTED] Sent: Friday, November 12, 2004 10:26 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Adding tables to form Sami, I tried that. I think it is just confused with too many common columns. Jan ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, November 10, 2004 12:42 PM Subject: [RBG7-L] - RE: Adding tables to form > Jan - > > If you are using many tables, you may need to check the many-to-many setting > on the form properties. > > Sami > > ------------------------------------------ > Sami Aaron > Software Management Specialists > 19312 W 63rd Terr > Shawnee KS 66218 > 913-915-1971 > mailto:[EMAIL PROTECTED] > www.softwaremgmt.com > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jan > > Johansen > > Sent: Wednesday, November 10, 2004 2:18 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - RE: Adding tables to form > > > > > > Huh! I want the links. > > > > The idea in a relational database was to utilize the ID's in each table. > > > > So in our scenario, in order to create a workorder you would need > > 1. A Customer > > 2. A Product > > 3. A Device (unique ID, link to customer, link to product) > > > > Now the workorder would be linked to a device, which is linked to customer > > and product > > > > I'm going to let it sit for awhile. > > Something you can look at it later. > > > > > > Jan > > > > ----- Original Message ----- > > From: "A. Razzak Memon" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Wednesday, November 10, 2004 11:54 AM > > Subject: [RBG7-L] - RE: Adding tables to form > > > > > > > At 11:47 AM 11/10/2004 -0800, Jan Johansen wrote: > > > > > > >Does having a common column between the tables 'link' them? > > > > > > Yup! That is the culprit in your scenario. > > > > > > If you don't want the link, you'll need to rename those > > > columns in slave table(s), except those with "True" link. > > > (matching column names and values) > > > > > > Very Best R:egards, > > > > > > Razzak. > > > > > > > > > > > > > > > >
