Calculations & Posting

James007

New member
Local time
Today, 08:53
Joined
Jun 8, 2012
Messages
8
Hi, i am just new to Access so your help is very much appreciated. I have started making an Inventory Conrol program. What i need to accomplish is when i recieve product in from a po to transfer the amount that is recieved and alter the inventory table. I have a table that contains the productid, the purchaseid the recv_date and amountRcv. Now i can get all the data to come up on the form recieving individual items. I also can input data into the form which alters my table for POrecieved but i don't know how to carry the Amountrecieved and add to tblInventory.recieved for the individual product and to subtract the ammount from tblInventory.OnOrder.

I hope this makes sense

James
 

Users who are viewing this thread

Back
Top Bottom