I have a field being completed with a lookup function.
I am drawing the customer contact information from a customer file. Occasionally, the value needs to be overwritten with a different contact, but I don't want the field in the source file to be changed . Currently, if we change the contact in a specific file, the contact changes throughout the database.
I would appreciate any advice.