subsummary report quandry

January 13, 200421 yr

I have three database files - Subjects Main, Subjects UF, and Subjects BT.

Their purpose is for a database of subject headings for books, where Main has unique headings. UF (Used For) contains subject headings that are obsolete - there can be zero or more of these. BT (Broader Term) contains a heading that is more general than the Main one - there can be zero or more of these as well.

There is a 1:M relationship between Main and UF, as well as Main and BT, Main being the parent is both cases.

What I need is a single report that lists each Main subject heading once, along with any associated UF heading(s), followed by any BT ones.

For example:


MainHeading1

    UF    UFHeading1

            UFHeading2

            UFHeading3

    BT    BTHeading1

            BTHeading2

MainHeading2

etc...

I'm not entirely sure if this is possible. The only idea I have is to somehow join together all three files into one file, which will yield some records with UF headings, some with BT headings, all with (a particular) Main heading.

Any ideas or suggestions?

Thanks in advance,

Kyle