Inventory Management

[Geoffk]

Hi AllI have a DB which tracks my daily work that currently I am adding inventory control to this and have found that the "MS Access 2007 Inventory Management" template could be manipulated to suit my needs.In the current DB I have a table "JobCodeSubForm" that contains the following fields. "JobCodeID, JobCode, Description, Payment."Each JobCode (approx 100) is made up of 10 individual items (approx 300).My question:Is it possible to update the quantity of each individual item located in the table "Inventory Transactions" (which I have inported along with other relevant files from "MS Access 2007 Inventory Management" template) when the "JobCode" is entered into the table "JobCodeSubForm"Thanking You in advanceGeoffk

 

[Fifty2One]

You can update or append the table if you code the sql statement on the after update event of the JobCode.