hello - i have attached sample database.
database has two tables [tblUsage] and [tblUsageInventory]
[tblUsageInventory] has 4 fields [tblUsage] does not have- Stnd Cost-User-Category-Parts Categories
Everyday [tblUsage] gets has its data replaced with new data - by automated service.
( * sometimes the number of records changes on the automated import process* )
The [tblUsageInventory] - users are adding data into the 4 fields( that are not in tblUsage) from a form daily.
how can i update [tblUsageInventory] with new data from [tblUsage] everyday?
or I should say just 1 day and I will then be able to figure out an automated process.