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?

Thanks for any help,

JD