What is the best way to compile certain rows from many tables into a emailable report?

[Driller]

I have three tables;

JOBS - Each row contains the data applicable to a Job .

BOREHOLES - Each row contains the Data for a specific Borehole within a job (references Job table). There could be one borehole or many in a single JOB

LOGS - Each row contains the data for different "depth intervals" within a Borehole. (references borehole table).  There could be one depth interval or many required in a single borehole.

How should I go about building this with the ultimate goal of the app user emailing a PDF report of a selected borehole which includes;

Borehole details (a single row from Boreholes), Job Details (the row referenced in the borehole data from JOBS table) and ALL of the rows from the LOGS table which reference the Borehole the app user selected.

Am I even going about this the right way?

[Driller]

FYI, I understand how to include the Job details as Dereference expressions.......where I am stuck is getting those multiple rows from the Logs table in the report.

[Steve]

<<Start: FILTER("Jobs", TRUE)>>
...info about the job...
<<Start: [Related Boreholes]>>
...info about the borehole...
<<Start: [Related Logs]>>
...info about the log entry...
<<End>>
<<End>>
<<End>>