many to one relationship

[kato68]

I have two tables that are linked in a many to one relationship. They are linked by ID number.
I want to create a report from the main table then show all the value that go with it in the many table.

For example,

In the main table I have:
ID = 1
Name = Kate
Address = Kate's Address

And in the many table I have 2 fields: ID and children
1 Tom
1 Billy
1 Jessica

How do I show all this on one page of a report. Is it a query issue or what?

 

[Pat Hartman]

Show the 1-side data on the main report and use a subreport for the many-side data.