* Parent table (Customers) Cust_PKey (Primary Key) Cust_Code CustName .... * Child Table (Invoices) Inv_PKey (Primary Key) Cust_PKey ("foreign key") Inv_Number ... * In many cases, with Invoices you will want multiple Invoice Line Items per Invoice, * so you'd want a child table of Invoices: * Grandchild table (InvoiceLineItems): InvLI_PKey (Primary Key) Inv_PKey (Foreign Key) Product_ID Quantity ....Using primary and foreign keys like this lets you link Customers, Invoices (and potentially Invoice Line Items) in the manner you want.