What is the most often selected field used for the Primary Key?

Discussion created by tbs on Oct 21, 2016
Latest reply on Oct 22, 2016 by Markus Schneider

When creating an online form in FMP which includes Company Addresses from many different related files. Which is the most common field chosen to relate the files to each other:


Account Number?

Phone Number?

Company Name?

A Custom field which combines data from many fields in the address?


I am trying to design the most flexible yet consistent approach for expedient data entry that will be most effective for the data entry person without bulking up the related files with redundant data created by continuous failed attempts to find a related record.


My initial thought is the Phone Number field as it remains somewhat unique and more easily identifiable by those familiar with a record. However, the consensus of a data entry staff is the Company Name field. Knowing the probability of errors when entering into a Company Name primary key field, I am hesitant to chose Company Name unless it can be configured to very tight specifications. IE Maximum number of characters, All Uppercase, etc.


Looking for the best recommendation and a solid justification.


Thanks for any feedback