>I have a table of child items (raw steel, bolts, tubing, paint, structural steel pieces, misc hardware, etc.) that we order from vendors through Purchase Orders and charge each item to a particular Job.
>
>Therefore, each record in this table is linked to both the Jobs table and the PurchaseOrders table by a separate foreign key for each. It’s link to each of these parent tables is equally important, and I cannot see how it is more related to one than the other.
>
>What should be the NAME of this child table?
>
>.
Those would be PO Lines. So, ummm... polines.dbf? Just as the "child items" should be called Assemblies... and before you accuse me of being contrary, I'll have you know that I agree with the names "Purchase Orders", "Vendors" and "Job".