stock control query

[halil]

stock control query- can anyone help??????

hi there
im a little stuck on how to make a query, wot i want to do is that , on my order form when the add order button is pressed, i want the quantity of the item to decrease by the quantity bought from the products table, how do i make a query for this, i have asked my teachers but they do not know how to do this.

 

[llkhoutx]

Run an update query on your products table decrimenting the number quantity on-hand with the quantity sold. Reference the field with the number sold on your form in your query.

 

[halil]

could you elaborate
what is the equation that i will have to put in the query

 

[llkhoutx]

StockOnHand: [StockOnHand]-Forms!YourFormName!OrderCount

 

[halil]

hi there
im still havin trouble with the equation , on on wot field do i put this equation

 

[llkhoutx]

As a column in your query.