Hello All,
Im converting our records system from a series of Excel sheets to an Access database. The data Im working with is keyed by "Permit Number" in the excel sheets, but there are multiple instances of each Permit Number as permits have been renewed through time.
In the ADB Ive appended the most recent record for each Permit Number to a main table with a new Key ID. I would now like to place certain fields from the larger repetitive data into an archive table that is keyed to the main table.
How can I transfer the Key ID from the main table so that it matches its multiple corresponding Permit Numbers in the archive table?
Hope this explanation helps, and thanks in advance.