>>>Do not rely on functions like recno() and deleted() when there are more than one table in the query.
>>
>>What about RECNO("kartei") or when a specific alias is specified. Does it work then?
>>
>No, as I said, never rely on recno() when it is not a single table in SQL. In one or more cases it might seem to work right, but I remember cases where it wouldn't. I just can't think of a good demo code right now.
When I've needed RECNO() values, I've selected from the original table with something like:
SELECT RECNO() as nRecno, * FROM table INTO CURSOR c_table
And then used that as the source for my subsequent query. Doesn't work well in views though, but can be a good workaround if it's manual code.