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:
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