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
I hope this makes sense
James
