How to change data in a table .

M

Martin Coole

I want to be able to keep a running total on how much
stock I have at any one time.When an order is placed I
need the quantity in products table to have the quantity
in the orders table deducted from it.
 
K

Kevin3NF

So run an update query to decrement the qtyonhand field for that particular
item when an order is placed, most likely in the After Update event

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top