Stock Levels

[torquay]

Hi hope someone can help. Thankyou in advance.

I have a small database for my warehouse that sells washing machines, fridges etc.

I am trying to get a grip on the stock control.
What I am looking for when a order is filled out on our order form is the stock number will reduce by the amount sold. Not sure how to make this happen.
I have the number of units in stock under the products table

ProductsID PK
ModelNumber
UnitPriice
Description
QuantityInStock

Sounds simple but for some reason I cannot figure it out.

Thanks
Kim

 

[Zigzag]

Hi Kim,

[QuantityInStock]=([QuantityInStock] - [orderQTY])

The above would be a typical example of the code used, although it is difficult to give a more accurate answer without a little more information on how you order form it built and used. If you post an example of your DB I could take a look.

Garry