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
--Todd Sherman
-Wake Up! Smell the Coffee!