When setting up a Table in a Database, it often is recommended that an auto- enter unique serial number record ID number be part of the setup.
Also that an auto-enter Creation Date and an auto-enter Modification Date field be included. Created by User and Modifed by User fields are also mentioned.
The unique serial number starts with a variable numbers of zeros and increments by one, usually.
It would appear that you have a number in a field of type text. Change the field's data type to number in order to get it to sort numerically instead of by text (alphabetic) sorting rules.
And yes, this is a common gotcha in FileMaker.
Thanks @PhilModJunk, I was storing the calculation for PointID as text as you guessed, though the two component fields were as numbers (see attached image). However, even recalculated and stored as a number it still sorts the same way.
I think I was using text format because at one point it was cutting off trailing zeroes, thus rendering 262.1, 262.10 and 262.100 as "262.1" (for example).
There must be something very fundamental (and foolish) going on here, no?
Check the result type specified for the PointID field. I suspect that it still specifies text as it otherwise should not sort like you show in your screen shot. There's a drop down list inside the specify calculation dialog where you specify the result type. with a number result type, a trailing zero after the last digit will not affect how the records sort.
@PhilModJunk I had changed the result type prior to my previous, and i redid the whole thing after your most recent, replacing the contents as an auto-calculation.
What you say makes sense, but I can't get the result I expect.
@DavidAnders, thanks to you also. I followed the FM forum link to Leading Zero's Padding. Whilst it looked at face value like I should have been able to use the pasted sample text [ SerialIncrement("000"; Self) ] to prepare the Autonumber field (to a uniform 3 digit integer) it didn't seem to do anything.
When i created a new field and the Autonumber field instead of "Self" I did indeed get my leading zeroes.
SerialIncrement ( "000" ; Autonumber )
I'll spew if the difference was merely whitespace.