Hi,

This is my first post here. I was wondering if anyone knows how to decrease a value in one field when data is changed on a seperate record, i.e. When placing an order, the quantity should go down (any value) in the "products" table and moved to the "orders" table.



Thanks for your help in advance.