Product structure of a file

T

TOMAC

I have 4 tables where one is a master table which contains a file number and
basic file information like subject of file etc, the second table has links
to the first via a common id field and includes person names, addresses etc
and there can be more than one person per file, the third table has data
related to a person's education and is linked to the second table above via a
common id number and there can also be many education forms linked to any of
the persons forms. There is also a comments form that contains comments and
this form can be linked to all forms.

I need to be able to view either in a report or a form, the product
structure of the data in these tables.

For example:

File 1 has a comments form and 2 persons forms associated to it. Each person
has 3 education forms associated to them and some of them have commenst forms
as well.

I need to see soemthing like this. Any help on this would be greatly
appreciated!

File 1 Comments
Person1 Comments
Education 1
Comments
Education 2
Comments
Education 3
Person2 Education 1
Comments
Education 2
Education 3
 
Top