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

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

you may also find this information providede by allen browne helpful. (http://allenbrowne.com/AppInventory.html)