Hello,

Just need a good start on a script.

I have an order form with a sub-form for every line items ordered. That subform source, with a lookup, product details, including actual inventory. Upon submitting the order, I want the quantities of every item ordered to be deducted from the product form's inventory.

I do not want to do it with entry in a field, since customer can go back-and-forth in changing items, or quantity ordered before submitting the order.

I need the proper syntax that says something like "for every line in this actual order" (not the mother form of line items), deduct the quantity of every corresponding item.

Sylvain