>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.