Doubled subsummary reports

[Gabe]

Hi. This is my first attempt at generating reports, and I am wondering if it's possible to use more than 1 subsummary sorted parts in a report.

The relationships are simple. I have a set of dockets, and each docket contains a list of civil suit records, which in turn have a list of plaintiffs and defendants within each case with their attorneys.

The report will basically give me a list of dockets for a given court date, and between each docket I want to see suit ID numbers, and between each suit ID I want to see a list of plaintiffs and defendants.

I'm not sure if it's possible to create a three-tiered subsummary setup like this.

Has anyone else done something like this before?

[aaa]

Any think like this?

See attacnment.

Subsummary.zip

[Gabe]

Yes, however, as I've come to realize, my problem is less about actually creating the report than it is about getting the recordset I need.

I have a parties table, a suits table, and a dockets table. In between those tables I have 2 join tables, "partiesinsuit" and "suitsindocket".

Im having a hard time defining a relationship that will result in a record set that I can use to sort parties between plaintiff and defendant within a suit record that is within a docket record when all of those relationships are split between 2 join tables.

I guess I should re post in the recordsets area.