D
Davo78
I 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 advance
Davo78
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 advance
Davo78