Post data from purchase form to inventory

[apprentice]

I need help with codes that will allow me to post selective data from a purchase received form to the inventory using a command button. this command should also add to the existing quantity in the inventory.

 

[jdraw]

Perhaps, but if readers are to help you, we need:

-an overview of the business your database is trying to support (in plain English)
-a jpg (zip format) of your relationships window

An overview of what you have tried, with what result.(error, wrong data???)

 

[apprentice]

when the purchase order form in filled out i will like to have a command button to post the information into the "Diesel" table, updating the previous quantities. i will also like the average price to be calculated when the cost is updated.