>I think the basic idea is something like this:
>
>

>select Master.Master, count(*) as HowMany;
>  from Master join Child on Master.Master = Child.Master;
>  group by Master;
>  into cursor Temp
>

>
>Additional adjustments may be needed if there is the possibility of master records without child records. A left join, for a start.

Yes, this works if I only have one field to use. But, using that approach when I have a lot of fields from the master table to include in the SQL will produce a SQL error on the GROUP BY.