I am building an inventory database for parts that go into producing a product.
I have a Product table, a Parts table, and goods in /goods out table. I also have a 'Transaction query' that takes goods in and subtracts goods out to produce a stock level.
This is all very basic and works ok.
I also have a Table that lists the individual parts that make up each product. Using this I have a form that when I select a product from a combo box it gives me a list of parts in a sub form.
My problem is at the moment as I sell a product I use the goods in/out table and 'Goods Out' the amount of each part to leave the stock level balance. Again this works OK. BUT some of the products have 20 parts and it takes ages to do this for each part everytime I sell a product.
What I want is a way to enter the Product name with the number sold that automatically reduces all the parts totals.
I have 8 different products each using some of the same and some individual parts which complicates it a bit. Reject parts can be dealt with individually.
I expect this has been asked for many times before but I have been trying to find a thread but not sure what to search for.
Any information will be gratefully received.
Graham
Thanks Graham