Multi Table Report not working

[Reige]

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

[Lee Smith]

Hi Rich,

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

Thanks,

Lee

[RalphL]

Get an error when expanding your attachment.

[RalphL]

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.

[Reige]

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.