>>>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
Yes :). I guess that when I typed this, I had a thought that there is better way to use primary keys instead of collecting RECNO(). Usually, attempts to use RECNO() indicate that table does not have primary key(s), i.e. design problem.
Edward Pikman
Independent Consultant