>>Is there any way to have SELECT selects RECNO()? TO make it harder I have more then one table in this SELECT statement.
>>TIA Mark
>
>You can SELECT Recno() From table1, i.e. querying one table. Having two tables, it's more reliable to dissect this operation, i.e. firstly collect recno() against one table and then join tables by second SELECT.

I would say that it's THE ONLY reliable way to do it. :)

Vlad