Printing from multiple related tables

[TDavidson]

I am creating a database to keep track of large vessel inspections and hit a snag on the reporting. The database consists of the following tables:

1-Equipment: Equipment information

2-Inspections: Summary of results/conclusions

3-Areas: Detailed results for each area (manhole)

4-Problems: Problems that need action

5-Recommendations: Recommendation for each problem

I tried to create a subsummary report with the layout showing records from "recommendations". Snag is that sometimes I do not have any problems or recommendations. When this happens, the information in the "areas" and "inspection" subsummary does not show up (obviously).

Any ideas?

Thanks,

Thomas

[RalphL]

Could you just use the word "none" in the problems and recommendations tables when there are no problems?

[TDavidson]

Thank you Ralph.

Felt like it was not elegant to create a bunch of empty records. This works.

Any recommendations on a how to automatically create related sub-records. Script?

Cheers,

Thomas

[RalphL]

A portal to the related table is a one way to create related records. The relationship must be set to allow creation of related records. Another is a button which runs a script, which copies the record ID to a variable, then go a layout for the related table, create a new record, set the foreign key to the variable, return to original layout and go to the new portal row.

I usually use the latter.