To add to Pauls solution:
>Build a cursor based on an outer join (both left and right) between children and pets.
Create a standard report form with a grouping by person. The child and pet names are displayed in the detail band and under "Print When" settings, specify that repeated values are NOT displayed.
I've tried this method and it seems to be the simplest...
Mark
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
