I have a user inventory file (TABLE# 1) and have added a date field "Last Scan Date".
I want to populate this field from another table (TABLE # 2) using the "Serial Number" field to link the records together. The table relationship would be "one to one".
TABLE 2 will be imported from a spreadsheet, and I want to REPLACE all existing records every time the import is run.
How can I set this up to run on a monthly basis?