How can I have a key field in a table native to Access be updated to reflect any changes to that same field in a linked table?
I use one field, CONTRACT_NUMBER, from a linked table as a key field in a native Access table so users can enter dollar values against the CONTRACT_NUMBER in the native Access table. If new contract numbers are added in the linked table how can the native table key field be updated with the new contract numbers?
I’ve attached an example database showing how I understand Access should be set up. My limited Access experience means it may not be set up properly to do what I need it to do. The only piece of the example DB that I can’t change is the table “SAP_LINKED_TBL_CONTR_FUND
”. This table is representing a linked table that gets the contract data that exists in our SAP accounting system.
To create the native Access table I used a "Create Table" query and copied the CONTRACT_NUMBER field from the linked table into a new table. Was this the right thing to do?
Thanks in advance for any help on this question.