Update Field On Differant Form

[Guest]

Hello...
I am quite new to this but i need to update a field from one form to
another.. I think im out of my depth on this one...

Order Componants for the Table and Form... Basically whena customer orders a
product i enter the quantity and i want it to reduce the quantity on another
Form/Table..so it needs to be linked to the Product ID.

Table = (Order Details) Field = (Quantity)
Form = (Order Details Subform) Name of Field on Form = (Quantity)

Inventory Transactions Componants that need to be updated from the quantity
above .. e.g i have 3 in stock.... 2 have just sold of product id 500
therefore the qty on the Inventory transaction needs to be 1...

Table = (Inventory Transaction) Field = (UnitsSold)
Form = (Products Subform) Name of Field on Form = (UnitsSold)

The only other problem i think is the fact that they made be 2 or 3 purchase
orders from differant suppliers of the same product...

eg.. PO No. 7 Supplier Ecko QTY 2
PO No. 1- Supllier Reflect QTY 4

Total of 6 on hand. But the qty needs to be taken of the Purchase Order...


As you can see this is a real mind bender and i am really stuck on this...
If anybody can help and needs more information i would be very
gratefull..Please contact me..

 

[[MVP] S.Clark]

You can either update the quantity when each child record is entered, or
wait until the entire transaction is complete, and deduct the sum of the
children. I would probably do the latter, such that you avoid having to add
when child records are deleted, but this may be unavoidable in the long run.

I also would not make changes to other forms, but instead, directly to the
appropriate table. This may require some VBA code, or executing an action
query via a macro action.