D
DJ matrix
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..
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..