Formatting data

[cathym]

I have two tables, Adult and Children with a one to many relationship. On a report I would like to have the name of the adult, and all the names of the children on one line. How can I accomplish that?

 

[MikeDNova]

if you create a subreport with a text box and use children as the control source, you can then place that within the main report and link the (child)subreport to a (master)control using a key.

hope that helps!
mike