Hi Fabio,

>This is not efficient ( on VFP9 the efficiency can be increased remarkablly ),
but this is the only possibility with a single SELECT.

It require a salesman number.<

Well... I can hardly believe this - guess this again proves the speed of a Fox. The parent table has about 3,500 records and VFP 7 processed this Select in a fraction of a second - .41 to be exact.

I already had a salesman number, so that was not an issue.

I really appreciate this, the code worked perfectly.

Mel Cummings