need help

[halil]

Hi there
im craeting a stock control system , i have four tables, products, suppliers, order, and order-product, what i want to do is , wen a item is sold , the quantity shud be deducted from the the quantity level , and also i want a text box come up wen it is below its reorder level , how to do i do that

thx in advance


buyyyyyyyyyyyy

 

[Fuga]

There are several ways you can do this, depending on your table structure and what information you want to store etc.

If you do not need to know anything about the product once it´s sold (actually I´m talking about product units), simply delete the post when sold.

If, however, you would like to keep the information, you could either have to tables (one bought and one sold) and then create a missmatch query. Or you could simply add a checkbox to your table for "sold", and then query it using -1 as the criteria for that field.

Then you can use Dcount() in an opening event of a form so that it checks the level every time you open that form.

Fuga.