Jan,
Take a look at the following forms in RRBYW9.
Database: RRBYW9 (Running R:BASE Your Way! Part 9)
Form: CustContAndSales Related Tables: Customer,Contact,InvoiceHeader,InvoiceDetail,Employee
Form: CustomerContacts Related Tables: Customer,Contact
Form: SalesTransactions Related Tables: Customer,InvoiceHeader,InvoiceDetail,Employee,Contact
Need more examples?
Very Best R:egards,
Razzak.
At 12:17 PM 11/10/2004 -0800, Jan Johansen wrote:
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.
