I have two tables
First is a linked table from an excel sheet (Table 1)
The second table has the data from the first table with a few added fields. (Table 2)
I want to be able to sync them. When a record is added or deleted from table 1 I want table 2 to update so the same records are in both.
Should I use an union query? If so, can you walk me through it?