update qty field in one table from a qty in another table

[rainbows]

HI,

Not sure if this is possible but i would like to enter a "qty reqd" "ie 6 as highlighted in line one In the orders table and it would update the "on order qty " in the stocklist table .. ie from 1 to 7

thanks steve

 

[Gasman]

Use an Update query.
What is the difference between [Qty Reqd] and [Qty Required]?

 

[rainbows]

the qty required is the amount to need to buy to cover the orders
the qty out is the amount you need to buy because you could have some in stock
the qty reqd is what the purchaser will actually buy incase he want to put some extra into stock

i dont know how to do an update query using a calculation