I have an inventory database of approx 500 items. Items are held by stock # but also a dept 4 digit number that is barcoded on a sticker placed on the item. Our db has"last Location" as a column. Every 2 years we scan our inventory and import a file that has dept number and new location. I use the duplicate function to see what we have missed but once everything is found I would like to update the location column with the new location data. I have put all of the new scanned data under the db in the same columns to use the duplicate function. Can someone show me how to do this besides manually going through the whole db? I do have a separate db of all of the scanned files as well if that is an easier way to do it. Thanks in advance!