Updating fields using a query?

[HeyYouYesYouNoNotYouYou]

Hi,

I am currently creating an inventory for stock. I have got a product table which has a stock field and i have a order table which will be updated through both manual input and order reports that will be pulled through from excel. What I would like to do is to subtract the stock away in the product table using the quantity ordered field in the order table based on which items have been ordered. I have linked up the tables using a primary and foreign key so is there anything else i will need to do to make sure that the appropriate records are being subtracted i.e if there is 50 of product A in stock, when an order for 10 of product A comes through the stock level will drop to 40 in the product table.

Thanks in advance,

Heyyouyesyounonotyouyou

 

[Joe4]

Isn't this really just a continuation of this question here: http://www.mrexcel.com/forum/microsoft-access/748060-how-use-relationships-mirror-mutual-field.html
If so, you will want to continue in that thread instead of starting a new one.

 

[HiTechCoach]

I would recommend taking a look at the Northwind sample database and the the Orders template.


Highly recommended reading: Inventory Control: Quantity on Hand

 

[HeyYouYesYouNoNotYouYou]

Thanks.

 

[HiTechCoach]

You're welcome.

Good luck with your project.