|
Yeah, I was just wondering if my view on the whole part,job order, and product table was valid...
I have been thinking about the making a table that contains a list of ingredients.
Probably something like
Product_Ingredient {
PartID - PK, FK to Product
ProductID - PK, FK to Product
qty (quantity needed for each quantity of product?)
}
__________________
Looking out the window, that's an act of war. Staring at my shoes, that's an act of war. Committing an act of war? Oh you better believe that's an act of war
Last edited by feelgood; 09-09-2004 at 10:51 AM..
|