>>
>>That sounds like normal behavior, it's staying on the same record, not necessarily the row. Usually, with a new sort, you either want to:
>>
>>1) stay on the same record, which is what yours is doing, I think?
>>2) go to the top
>>
>>So, are you sure it's purely random and not #1 here?
>
>It stays on the same row in the grid, but the record changes.
>
>ie, I'm on tom jones, I click on the firstname field, and I'm on carol adams.
Depends on sort method, I guess. A SET ORDER keeps the same record, where a new INDEX ON will go to the top. I almost always go to top anyway in my grid sorts, but Mike's suggestion is the way to go if you're doing fresh INDEXes and want to keep your record.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.