Nicholas,
I'm glad it's working now. As for the 'new-fangled JOINs' you do have to be careful about syntax. However when you need a left join instead of the default inner join you will suddenly get converted. I sweat blood in VFP3 trying to get an outer join equivalent working between multiple tables. In VFP6 it's just a matter of clicking on the right type.
Barbara
>
>I got the code working. I have no idea why the example I showed did not work the first time. I may have gotten confused with some other tests use the new-fangled JOIN and its related statements. Unfortunately these appear to be junk. I have never been able to make them work. I even copied the statements from the View Designer and just make one change and everything blows up. They appear to be useless.