RESOLVED: Multiple Lists from Multiple Queries - Need Page Break on Common Item

[adam_mc]

Sorry, having a little brain freeze and hope someone can help me out quickly...

For a Dimensional Data Source:

I have a Report containing 4 lists produced from 3 Queries.
Each has a common element, say Product ID.

I need to create a page of output for each Product ID.

Tried Sectioning each list and setting Page Break, but output is unpredicatable and not as required.

Would greatly appreicate any help.
Thanks in advance,
Adam.

[Lynn]

Sorry, having a little brain freeze and hope someone can help me out quickly...

For a Dimensional Data Source:

I have a Report containing 4 lists produced from 3 Queries.
Each has a common element, say Product ID.

I need to create a page of output for each Product ID.

Tried Sectioning each list and setting Page Break, but output is unpredicatable and not as required.

Would greatly appreicate any help.
Thanks in advance,
Adam.

You could try creating a query that has only the product ID in it. Associate that query to the page and set a page break.

Then create a master-detail relationship between that query and each of your list reports based on product ID.

[adam_mc]

Thanks Lynn that worked perfectly.

Knew I'd done it before, just a little reminder needed.

Thanks so much,
Adam.