>Hi All,
>
>I have a problem with the Query Designer. I have simplified the query for this question. Basically I am selecting every entry from a ledger file and then picking up descriptions for the transaction code and payment method from their master files. The correct number of records are being generated. The following code is generated by the designer but has 2 problems.
>

As Barbara mentioned, there is a problem with the query/view designer. I'd recommend writing the query in code..and making it two instead of one query. VFP will only join two tables at a time. This is explained in the Rushmore KB article on my web site.