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,
 

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

Similar Threads

Sum duplicate lines in a table 1
Want stock to update in stock table when order is made in order ta 1
deduct stock from a table when order placed in another form for or 9
Using an update query to update amount in stock automatically 1
How to add records to a subform from a listbox on a different form 2
How to UPDATE a field in a joined table? 8
Managing Stock 3
How do I group identical records? 2

Top