Combine nested related tables for printing

[mikeytt]

Hello - hopefully someone can point me in the right direction for this.

I have three related tables - Quotes, Headers and Data. The quote table holds several headers, and each header holds several Datas.

What I want to be able to do is to be able gather and print all that information in one page, like below.

Quote X

Header A

Data 1

Data 2

Data 3

Header B

Data 7

Data 8

Header C

Data 13

Data 14

Bearing in mind that the number of headers for each quote can be variable, and the number of datas for each header are also variable, so a quote could have as many as 10 Headers, each of which could have 10 or more datas. Overall though ,the number of entries is unlikely to be more than 100.

From what read so far, I think i need to create another table where i extract all this information to line by line and then use that for printing? Not sure if this is the best or correct approach though. Any help greatly appreciated

[comment]

From what read so far, I think i need to create another table

Not at all. Produce your report from the data table, with sub-summary parts by header and by quote.

[mikeytt]

Not at all. Produce your report from the data table, with sub-summary parts by header and by quote.

Fantastic - that works, exactly what i wanted. Thank you.