TKnTexas

Unique Compound Key

Discussion created by TKnTexas on Mar 29, 2016
Latest reply on Mar 29, 2016 by Mike_Mitchell

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?

Outcomes