Thanks guys,
I left out the SET SKIP
Chris


>select child
>index on keyfield tag keyfield
>select parent
>set relation to keyfield into child
>set skip to child
>----
>in report, make a group band on keyfield, place parent records in group bands, place child records in detail band.
>
>>The results are 2 cursors, one header and one detail
>>
>>
>>Chris
>>
>>
>>>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