How To: Create a sequentially ordered ID field on a sorted table
This article walks you through the process of creating a sequentially ordered ID field, which is based on the order of the records after a sort, and not based on the internal VTab record number that the Rec command uses.
Sort the table on the desired field. Use the Ascending or Descending sort buttons:
Add a new number field to the table.
Open the table and select Start Editing from the Table menu.
Select Add Field from the Edit menu.
In the Field Definition dialog box:
Set Name to an appropriate name, for example 'Area'.
Set Type to Number.
Set Width to an appropriate number, for example, 32.
Set Decimal Places to the desired number, for example: 6.
Select Stop Editing from the Table menu and save the edits.
Select the new field field, and click the Field Calculator button.