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.


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
3NF Consulting

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