AnsweredAssumed Answered

Choosing field types for key fields?

Question asked by Embee on Mar 30, 2012
Latest reply on Mar 30, 2012 by Embee


Choosing field types for key fields?


Hi fmp's,

In trying to adopt some best practices while learning fm, I am wondering what field types should be used for PrimaryKeyFields and ForeignKeyFields.

My PrimaryKeyFields are always going to be "auto-enter serial, can't modify auto", but since both Text and Number are available field types for both the pk's and the fk's; which type is the "better practice" in each key? Or what are the considerations?


- Emmbee