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

Is it a junction table? How about JobsOrders ?