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. > > > > > > > >
