>>1. RecNo() is reliable only on SELECT from one table
>>2. RecNo() is always applied to the source table
>
>Nonono, not add the recno to the cursor, use it on the cursor. AFAIK, all Porter wants to due is see 1 if your on the first Record, 2 if your on the second, and N if your on the Nth.
So, Select *, recno() from table1 inner join table2 on ... Would not work? Thanks for this warning.
If it's not broken, fix it until it is.
My Blog