>>I know each table should have a pk - but in this case, alas, it does not
>>
>>Recno() with one table to produce a derived table works fine - take my word for it
>
>Does it work joining back to itself? We need this PK in order to JOIN back and get the actual row.


It it's the first derived table - it can go back to the physical table

But a derived table ( with recno() ) on another derived table ( with recno()) is another matter