surely a simple report?

[Not Me]

Hi,

I have two tables/queries, one lists reference numbers and information, the
other holds those number and different information.

I want the second set of data to be displayed in a subreport, to be added to
a report which holds the first set of data, linked up by reference numbers.

The problem is that I wish the subreport to be grouped up, as there is a
one-to-many relationship. My best efforts have only resulted in a new page
for every single element in the subreport...

Any hints?
Cheers,
Chris

 

[MacDermott]

Are you using the LinkMasterFields and LinkChildFields properties of the
subreport control?

- Turtle

 

[Not Me]

added

Are you using the LinkMasterFields and LinkChildFields properties of the
subreport control?

Yeah, it links up fine, just I'd rather have each page show all records in
the subreport, rather than just one subrecord on each page... if you know
what i mean!??

Cheers,
Chris

 

[MacDermott]

Check the Detail properties of your subreport.
Perhaps NewPage is set to either Before or After?

- Turtle

 

[Not Me]

is

Check the Detail properties of your subreport.
Perhaps NewPage is set to either Before or After?

Thanks, but that ain't the problem
I'm sure I've done this before and it's worked fine!

Cheers,
Chris