UPDATE TABLE FROM ANOTHER

[macke]

I have 3 tables. One is a Inventory

STOCK_CODE/DESCRIPTION (LOOKUP FIELD)/ LOCATION/ NO OF BOXES/BOX QTY/QTY (CALCULATED NO OF BOXES * BOX QTY.

the others are Stock_In and Stock_Out.

The user opens either Stock_In or Stock_Out, inputs the Stock_Codes received, No of Boxes & Qty per Box and presses a Save button. I would like the calculated Qty field in this table to update the Qty in the Inventory table. Obviously either subtract in the case of Stock_Out and add or append in the case of Stock_In.

Any help appreciated

 

[TonyMcGuire]

You should be able to link Stock_In.db and Stock_Out.db to Inventory.db on each form on STOCK_CODE.

The save button on each form can just take the # of boxes times Qty per box, and add/subtract this from the Qty field as appropriate to each form.

Being linked, the form should prevent other users from changing the specific record while this entry is being done.

Does this answer your question?


Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[macke]

Hi

Yes it does make sense, but not sure of the code to attach to the save button.