Greetings,
I am confused as to just how something works in the Northwinds sample.
When you add a qty of items ordered to an "Order", the Field labeled
"Units On Order" of the "Products" form automatically calculates the
Sum or total on order.
As you add more Qty's to "orders", this number goes up and likewise
if you change the qty to a lower number, it Removes the correct Qty
from "units on Order".
My question is, How ? I would expect to see an "afterupdat e" event or
something in the Orders Qty field to update (add/subtract) the correct
amount from the Products table.
I need to accomplish something similar. A Qty field from a PO form
needs to update (add or subtract accordingly) an On Order field in an
Inventory table. In my case, I need no relationship to any qty
received.... Just need the Inventory field "On Order" to go up or down
accordingly.
Can't seem to find some sample code to do this.
Your help appreciated !
Chris L
I am confused as to just how something works in the Northwinds sample.
When you add a qty of items ordered to an "Order", the Field labeled
"Units On Order" of the "Products" form automatically calculates the
Sum or total on order.
As you add more Qty's to "orders", this number goes up and likewise
if you change the qty to a lower number, it Removes the correct Qty
from "units on Order".
My question is, How ? I would expect to see an "afterupdat e" event or
something in the Orders Qty field to update (add/subtract) the correct
amount from the Products table.
I need to accomplish something similar. A Qty field from a PO form
needs to update (add or subtract accordingly) an On Order field in an
Inventory table. In my case, I need no relationship to any qty
received.... Just need the Inventory field "On Order" to go up or down
accordingly.
Can't seem to find some sample code to do this.
Your help appreciated !
Chris L