Fine,
I just want to add, on top of the recno not being in order, if an index order is set, the recno also has no deeper meaning and is even no key to a record, because after a PACK the recno of the same record can change. RECNO is only of temporary meaning and can be used to eg initialize an ID integer autoinc field. You should add a primary key to any table.
I would also suggest to not even use that ID primary key field for reference on reports, on screen or via phone, that should always be a secondary unique key, the records primary key is best a kept secret for inner working of all applications involved.
That's a very strict opinion on the matter and can be seen relaxed anyway, but be prepared to see something fail, if you rely on a recno as permanent reference to something. If you merely wanted to see how to display something different than a field value in the grid, fine, if you merely want this for current reference or orientation, also fine.
Bye, Olaf.