Report Troubles

[Brian Spolarich]

I'm new to FM7, but familiar with relational databases. I'm stuck on how to get FM to do what I want.

I have a relational database related to product manufacturing. Here are the tables and relationships:

HPTC - Details on source materials. PK is HPTC_LOT_NO.

RAD - Each RAD entry has a FK from HPTC. PK is RAD_LOT_NO.

DEVIATIONS - Each entry has a FK from HPTC or RAD. PK is DEVIATION_NO.

QC_RESULTS - Each entry has a FK from HPTC or RAD. PK is ACCESSION_NO.

What I want to do is create a report that provide the complete details for a particular entry in RAD. This should include all of the relevant details from RAD (that's easy), plus a summary of all of the related entries in DEVIATIONS and QC_RESULTS. As a bonus, it would be ideal to only show the entries in QC_RESULTS where OOS (out of spec) == 'YES'.

I know I can somewhat accomplish this via portals, but portals have a fixed size, and I want to provide a "print to PDF" report that can easily be distributed. I think I should be able to do this through using various parts and summaries, but I am not finding examples that help me and my tests don't yield good results.

Help!