Products in stock

[Planet Internet Nieuws]

Hi,

I have a table wiith products, that can get ordered via a form that contains
orders. Each time a product is ordered in the form, I want the amount to be
deminished form the products table.

Any suggestions how I can get this to work?

I found a solution myself by using a temp table and an update querie, but
this is too slow.
Any suggestions?

Wiro

 

[Kevin @ 3NF]

Leave out the temp table and run an update query from code (or call it from
the code). In an application I recently played with, I set this code in the
AfterUpdate event of the Quantity field, but that may not be best for you.

If you have multiple users, you will need to take that into consideration.

 

[Sandra Daigle]

Inventory/Stock Qty on Hand is usually calculated from stock transactions.
Allen Browne has an excellent article that explains the general concepts and
offers some guidance on the most reliable ways to implement this:
http://users.bigpond.net.au/abrowne1/AppInventory.html