>>Did you try the syntax for connecting to the DBC instead of just free tables?
>>
>>lcConnStr="Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;"+ ;
>> "SourceDB="+HOME(2)+"data\Testdata.dbc;"+ ;
>> "SourceType=DBC;Exclusive=No;BackgroundFetch=No;Collate=Machine;"
>
>They are free tables. :( And now I have more to contend with, I have to join the results of two joins, giving an end result of 4 joined tables. What a mess to take wonderful normalized data and undo the normalization so that some IT dept running in the dark ages can access a flat EBCEDIC file...
>
>Anyway that we can perform a join against a pair of recordsets?
>eg:
>make rs1 and rs2 then
>select * from rs1 inner join rs on rs1.fields("HD_ID_NUM") = rs2.fields("IN_ID_NUM")

Never mind that filtering with the criteria. I must have been thinking of something else when I wrote that.