>Hi there
>
>I have a problem:
>if I use recno() it will give me the 'entry place' in the table. however if i set an index the first entry in this ordered list might be the last record in the table.
>how can i find out which entry in the list it is?
>
>thanks for your help
>Gunnar

---

< Cetin >
"Record number from an index"

lcKey = key()
select &lcKey, recno() as Physical from my table order by 1

< /Cetin >

PS. Due to a problem Cetin could not send this message by himself. That's whyhe asked us to send it.