>Hi
>
>When you use recno() in select statements, is it reliable?
>
>In some old Fox2.6 apps we have duplicate keys and I need to differentiate between them.
>

It's reliable in queries involving a single table, as long as you don't put the alias inside the function call. It's not reliable in a multi-table query.

Generally, the best solution is to use one query (or a derived table in a larger query) to add the recno to the original data, and then another query (or a containing query) to pull the data you need including the recno into the result.

Tamar