I'd suggest pre-processing the data to create a single parent-child relationship where the child file contains field for ChildName and PetName. For some child file records, the pet name would be empty and for others, the child name would be empty.

HTH

Larry

>Set up your report data environment with the parent-child in relationship.
>
>Basically, in the report, the detail band would be:
>
>Parent.name
>"Children Pet"
>-------GROUP BAND ON PET------------
>Child.name Child.Pet
>
>
>How's that?
>
>
>
>
>>Ok - riddle me this,
>>
>>How can I get a report to print with a parent record and multiple-table child records? For example, suppose my parent table is "Person" - a person can have children and/or pets. How can I get the report to print something like this.
>>
>> JOHN DOE
>>CHILDREN PET
>>---------- ---------------------------
>>Bobby Fluffy
>>Tommy Spot
>>Sue
>>Ann
>>
>>JIM SMITH
>>CHILDREN PET
>>---------- ---------------------------
>>Sam Fido
>> Flipper
>> Lassie
>>
>>Of course any given person may have any number of pets or children or none or some of both or either (wow- that was mouthful). I'm playing with various joins to see if I can come up with something the report writer can deal with. Any ideas?