AnsweredAssumed Answered

Primary Key Data Type

Question asked by MarieT on Feb 5, 2010
Latest reply on Feb 8, 2010 by mrvodka

Title

Primary Key Data Type

Post

I am new at FMP 10 and want to understand why when you create a Primary Key that is an auto generated seriel number the data type used is text?  That makes no sense to me since the type is obviously a number. 

 

I am referring to all of the pre-made fmp examples that come with 10.

It makes sense to me that the data type would be number so that it could be indexed and sorted as a number.  The data Type of text does not do that.  Help.  What don't I understand?

 

My friends who write SQL databases tell me NEVER make a Primary Key text.   HELP????

Outcomes