AnsweredAssumed Answered

Choosing field types for key fields?

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

Title

Choosing field types for key fields?

Post

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?

Thanks,

- Emmbee

Outcomes