Scenario: Substracting Items from Storgae when purchased

[dbmanalser84]

I have a table in my database that holds items and their quantity and that table represents the storage.
I have a table that represents a cross table and holds the infromation about items sold and the date they are sold, and I have a form for entering data in that table (matching items with the date they are sold and the quantity for each item).
How do I create that when I enter the items that are sold in that form (table) their total number from other table (storage room) is substracted?
Is this done with some type of query, and how exactly?
Thanx.

P.S. - Sorry if this is in wrong section.

 

[Rabbie]

There have been a lot of posts about stock/control and Inventory here. Try using the Forum search facility. Also Allen Browne's site has some good information that you may find helpful