I need to outputa grouped set of data from an Access database using CF.
Basically a Person can be associated to many positions, programs and interest
groups.

I have the following tables/columns:
PERSON (parent table PK Person_ID)
-First_Name
-Last_Name
-etc
POSITION (child of Person, PK Position_ID, FK Person_ID)
-Position_Name
PROGRAM (child of Person, PK Program_ID, FK Person_ID)
-Program_Name
INTEREST_GROUP(child of Person, PK Interest_Group_ID, FK Person_ID)
-Interest_Group_Name

I need to display the data like this:
John Doe
Position(s):
- Staff
- Consultant
Program(s):
- Animal Disease Research
- Human Disease Research
Interest Group(s):
- Disease Outbreaks
- Emergency Response

I have been trying to get the data displayed above using nested grouping from
a query that joins all the tables as well as subquery selects and have had no
luck,

I would greatly appreciate any help/feedback.
Thanks in advance.........