John,
RECNO() can not be used in multi-table SELECT statements. Besides it's better to be using each table's Primary Key. RECNO() does take an alias argument recno( "table1" ) instead of table1.recno() but that's not going to help you at all in this case.
>I'm trying to use recno() as a field in a SQL-SELECT statement from multiple tables and I can't figure out what determines which table it gets the record number from. If I try to qualify the field, as in 'table1.recno()', I get an error ('Object table1 not found'). Has anyone else encountered this?