How to manage stock in a table from a subform

E

Egidio

Hello,

I have a form (frmOrders) with a subform (subfrmOrders), the Subform
in datasheet view and it allows the user to enter online orders of
various products (1 product per line), these products are chosen from
a table (tblProduct, constituted by idProdct (PK); nameProduct;
qtyStock; priceToSell).

When entering the order it is recorded in the table orders
(tblOrderDetails), but I do not know how to quantities in stock of
tblProduct be updated (removing the quantity in stock value that was
registered for sale to the customer).

Can any one give me a help?

Thanx,
 
Top