Christopher,

Do you mean that the result of the Select is a flattened file, containing repeating values for the parent and unique values for the children? If so, just group on one of the parent fields.

>Anyone know how to get one to many reports to work
>where the results are generated form SQL selects into cursors?
>
>Thanks,
>
>
>Chris