>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?
>
>.
I would also call it JobsOrders, unless you come up with a better, succinct, description of the purpose of the table. For example, perhaps the description of the table is "This table stores information about how purchase
orders are
assigned or
charged to different
jobs" (you decide whether this accurately describes the purpose of the table or not!), you can use some of the words which I put in bold for the table name, which gives you one of the following alternatives: OrderAsignment, OrderCharge, OrderJobs.
In the above general description of the table I may have missed the point completely, but the point is to get some description of what the table does, and then either use some key words from that descrition (not words like "information" or "store" that apply to any table!), or alternately, if the table joins two other tables, use parts of the two table names for the join table.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)