Inventory / Mfg database

[reidhaus]

Having a little trouble creating tables/queries/etc that will accurately track our inventory. I don't seem to have a problem with creating tables/forms, etc that are used for receiving inventory - but the sales part is causing me grief.

We don't actually sell these inventory parts individually - they make up part of a larger product. What I want to do is create a form to input the number of products sold that automatically takes out the individual parts out of the inventory. I don't really know how to make tables that will allow me to do that. If anyone can help I'd appreciate it - and I can upload the db I'm working on to Mediafire if necessary.

 

[DCrake]

The key word you are looking for is BOM Bill Of Materials. You need to create a table that has the finished product ID and a component ID. Think of it as a receipe.

So when you pick the product it automatically gets all the ingredients from the table that make up the finished article.

 

[jdraw]

There are some sample data models at this site that may be helpful to your database design.
http://www.databaseanswers.org/data_models/index.htm

http://www.databaseanswers.org/data_models/products_orders_and_deliveries/index.htm

M$oft also has some downloadable templates -- (inventory) that may be useful. May give some ideas on different aspects...
http://office.microsoft.com/en-us/a...lates-you-talked-we-listened-HA001234159.aspx