>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
RECNO() is unreliable with multi-table joins. This is documented in Help.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer