I have two FMP files. One is simple people with a unique PeopleID, the other file is Deals with a unique DealID
I have need to look up & add 8-10 of these people into the Deal file & LookUp doesn't seem to be the way! When triggered by PeopleID it changes all of the name fields to the most recent ID# Lookup.....I know, stupid of me!!Yikes
What is correct structure to perform this?