hello
I’m looking for help updating a local table in access using a linked table in the same DB called ALLELEMENTS linked from Excel. Really the DB works fine using the linked table because I’m mainly use it as a dashboard and for reporting but I also need to add info to the records so I made a copy of ALLELEMENTS and added the fields I needed.

I can’t figure out how to –
-Get the local table that includes a couple of new fields updated with new the new data (new records and updated sales figures, dates etc.) from the linked table.
- Can I make a relationship between the linked table and the local?
I only have 3 tables In my database
tbl ALLELEMENTS (linked)
tbl ALLELEMENTS2 –same as ALLELEMENTS with a notes field
tblSALESREP

all the forms and reports will be based off of queries from ALLELEMENTS2