Primary Key Data Type
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????