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

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

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

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.