Primary key field sorts out of order
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:
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.