Updating Tables

[Kira]

Note: I did try searching before posting

Alright so I have a table titled "Current Inventory". This table consists of item IDs, the item name, and the current amount of that item among other things. I currently have a form which edits a table titled "Inventory Use" which is used to display when items are used and how much are used. Problem is that I need the "Inventory Use" table values in the quantity used field to be subtracted from the "Current Inventory" table so that I can always have an accurate table on what we have in stock. Do you make a query for this or do I need to make a form from a query that simply updates the "current inventory" table without the need for a "Inventory use" table? If so how do I do it? I am at a loss on how to get it to work.

 

[pbaldy]

Personally I wouldn't try to store the quantity on hand, rather I'd calculate it from transactions. Here's a discussion of both:

http://allenbrowne.com/AppInventory.html