AnsweredAssumed Answered

Primary key field sorts out of order

Question asked by JosephFalduti on Jul 24, 2015
Latest reply on Jul 25, 2015 by philmodjunk

Title

Primary key field sorts out of order

Post

I have a portal linking to another table that I am trying to sort in descending order by primary key field, so that the most recent entries appear at the top.  Some of the recent entries have been sorted down lower and mixed in with older entries.  Upon checking the table itself and sorting by primary key field, I realized that after 1000 entries, the field is sorting by the first 3 digits.  This might have been my mistake, as I set the automatic entry to be three digits, like "Note001" with increments of one.

Now I'm getting a descending sort that looks like this:
note1122
note1121
note112
note1117
note1116...
note1110
note111

Is there a way I can fix this without having to manually reset all this?  Keep in mind that this is data linked to another table.  Though, it's linked through the primary key field of that other table, so I think changing the IDs shouldn't be a problem.

Thanks.

Outcomes