I receive data from a system. It comes in the form of a spreadsheet. There are two key columns of Data: Client and Agent.
There might be multiple records for Client "A". But Client "A" can only have one agent type. Adding a new client is not too difficult. That gets flagged to me separate from the report. However, a Client may add a new agent type. So before I import the report to the activity table, I would like to update the Parent Table, to pick these new agents up.
Should I concatenate the information in Excel first to create the key? Or can FileMaker Pro determine uniqueness from a compound key?