How to change data in a table .

[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.

 

[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