Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opinions on a table name please...
Message
 
To
13/05/2010 23:04:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01464518
Message ID:
01464563
Views:
70
>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".
Previous
Reply
Map
View

Click here to load this message in the networking platform