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?
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?