Just to be clear: using recno() with param will ALWAYS give incorrect results (even when only one table is involved). The same goes for many other functions that take an alias as param.

Vlad

>RECNO() is not a property or field of a table, so 'table1.recno()' can't work in any situation. You can, however, use RECNO('table1') - !BUT! you may (probably) get incorrect results when using this in a multiple-table SELECT. The best way is to SELECT RECNO() into a temporary cursor, then use that instead: