Hi all,

I have attached my database file with the hope someone can help me get over this problem.

I am trying to develop a database which provides a report based on 3 tables which are linked together.

I generate a report with sub summaries but It shows me a single field from the main table (Document) with records for each individual record in table 2 (section) which relate to the record in the main table, but doesn't then repeat for the next record in the main table OR show the records in the 2nd table as a list below the record from the main table. It doesn't show any records for the 3rd table. Is this a relationship problem with my tables.

I know it might sound complex but any help would be greatly appreciated.

The tables, with the relationships, are:

DOCUMENT --1--M-< SECTION --1--M-< SUBSECTION

Reminds me of sub reports in access.

The report I am looking for needs to look similar to the following.

DOCUMENT

-->SECTION 1

-->section 1 text

-->Sub Section 1.1

-->subsection 1.1 text

-->Sub Section 1.2

-->Subsection 1.2 text

-->SECTION 2

-->section 2 text

-->Sub Section 2.1

-->Subsection 2.1 text

-->Sub Section 2.2

-->Subsection 2.2 text

END OF Report

Thanks for any help.

DocumentationCopy.fp7.zip

Hi Rich,

Please update your Profile to reflect the Platform, OS, and version of FileMaker you are using.

Thanks,

Lee

Get an error when expanding your attachment.

Reige,

Please try compressing your attachment again. I have tried 3 times to download it and all failed to expand. I would like to see your files so that I can see if there is a way to make your report.

Thanks for your replies, sorry have been away. I have solved the problem by going to a single table, as FM support recommended. This seems to be the only solution as I have tried everything. It may not be pretty, but it works.

Thanks very much for your help,

Rich.