>Sure. After the information about the case itself (the header), they want the Attorney and Party data to look like this:
>
>
>Attorney Julie Nagle
>---Plaintiff Bob Bridge
>---Plaintiff Helen Bridge
>
>Attorney Ben Bogle
>Attorney John Doe
>Attorney Nancy Golden
>---Plaintiff Roger Randle
>---Plaintiff Geri Randle
>---Plaintiff Jennifer Randle
>---Plaintiff Henry Randle
>---Plaintiff Percy Wilson
>
>Attorney Jim Daniels
>Attorney Frank Smith
>---Defendant Amy Black
>---Defendant George Green
>
>Attorney Henry Prince
>---Defendant Mary French
>
>For each Case, there is at least one Party on each side; each Party is represented by one or more Attorneys. The problems with the report formatting come when they share Attorneys.. The data structure doesn't really facilitate grouping them. The Case is the 'parent', the Party the 'child', and the Attorney the 'grandchild'--and 'grandchildren' can be (and are) entered multiple times.. In this example, there are 20 Attorney records, but only 7 distinct individuals.


What does the data look like before you start? Is everything in one flat file .. or do you have more than one table you are pulling from?