Products in stock

  • Thread starter Thread starter Planet Internet Nieuws
  • Start date Start date
P

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
 
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.
 
Back
Top