Merging Inventory Tables

[Mike via AccessMonster.com]

I am trying to update one table (Master inventory) from 3 seperate tables
that recieve imports from hand-held scanners. Each day, the scanners get
updated with a master inventory, then the individuals go inventory, import
their data back into Access and that is where I am stuck...merging the 3
files back into the master with only updated data...what is the best way to
do this?

 

[PC Datasheet]

The presumption has to be that the three individuals do not inventory the
same item. If this is the case, import the file from the first scanner and
ceate a query that joins the ItemID of this table to the ItemID of the
Master Inventory table. ONly include the Inventory field of the Master in
the query. Change the query to an update query. Where it says Update to,
enter [Scanner1Table].[Inventory]. Run the query and the master inventory
will be updated with the inventory on the first scanner. You can repeat this
process for the other two scanners. Again, if the three individuals do not
inventory the same item, the master will be correctly updated.

Mike, I would appreciate it if you would provide information on the type of
scanners you are using.

Thanks!