Hi Shane ---
This works best if your index order is based on a unique index:
USE customer ORDER lastname
COPY TO ARRAY aLogOrder FIELDS lastname
SELECT customer
SEEK "Smith"
nLogicalRecord=ASCAN(aLogOrder,customer.lastname)
>Does anyone know how to get the logical record number when you have an index order set. For instance, a customer table is indexed on last name. The 1rst record in the customer table might be the 10th record displayed when the index order is set to last name. I am looking for a quick function that would work like the go command ( ex. gological(10) ).
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05