May 18, 200520 yr 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?
May 18, 200520 yr Author 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.
Create an account or sign in to comment