Auto Number Records Alphabetically

301
0
02-04-2020 10:12 AM
JoshSaad1
Occasional Contributor II

To avoid too much clutter, I made a large map that uses number labels to identify points rather than full text.  I added a table listing the tenant name and address of each numbered location.  The numbering is based on the Object ID field, but it's kind of confusing as the list is sorted alphabetically by tenant name, and the numbers are basically in the order that the tenants were added and not in the order that they're listed.

Is there a way to generate auto-incrimenting numbers in a separate field based on the table being sorted alphabetically by tenant name?

I tried following the process in this article: How To: Create sequential numbers in a field using Python in the Field Calculator, but it still sorts items by Object ID.

Does anyone have a suggestion on how I might be able to do this?

0 Replies