Stephen,

>in foxpro 2.6x (DOS) I have a multiple-table querie where the recno() just so happens to be returned from the table that I want and it works fine.

Then you just happened to be lucky in this one situation. FoxPro from 2.5 on has not guaranteed what value would be returned by the recno() function in multitable queries.