February 15th, 2010, 09:55 PM
posted to microsoft.public.access.tablesdbdesign
|
|
Part and Product Database Help
Thank you all for your help
"mglg01" wrote:
I need help designing a database for parts and products. I'll give you a
brief description of the scenario:
There are thousands of parts, and hundreds of products. I want a database
that has the following:
-a list of the parts - with description, product number, color, length,
etc.
-a list of the products with the associated parts included in the product
-If I change a description of a part, I want it to change in the
products and all related aspects
I know I need a part table, but I don't know how to incorporate the products
- because the parts can be used for more than one product.
Any help, comments is greatly appreciated!
Thank you
|