A single report with multiple rows of a table?

[nsmith]

Hello,


Hopefully I can convey what I am trying to do here. I have a report that pulls information from a query. The query pulls information from multiple tables by a primary key(for one of the tables). In some of the tables the primary key(which is being queried) is connected to multiple rows.

example:
table 1 fields:
ID1(PK being queried), type, date
Table 2 fields (multiple ID1s):
Table2ID(ex. 1), Material, ID1
Table2ID(ex. 2),Material, ID1(same as above)

When I run the query it pulls up all the rows but when the query is pulled in to the report it only brings in one row per page. I would like to get it all on one page. Is there a way I can do this?
Sorry If this is a bit confusing I am having trouble explaining it.
Thank you

[June7]

Size of the Detail section can control how many records show on one page. Size it so the bottom of section is up against the textboxes. Also, look at the ForceNewPage property of the Detail section.

[nsmith]

That works somewhat but I have items below which also need to be displayed. I tried adding another group and that will show the multiple values but every group below that one will also be shown again even if the values are the same. Is there a way to repeat a group without repeating every group beneath it. I can't just have that group on the bottom either because there are other fields that require the same treatment (multiple values need to be shown on the same form.)
Thank you

[June7]

Do you want to provide project for analysis.

[nsmith]

Unfortunately I cannot because this database is for my company and they don't want me to make it available. Thank You though.

[June7]

Don't care about data, just structure. Follow instructions at bottom of my post if you want me to analyse further. Some dummy records would be helpful to test with.