Jump to content

subsummary report quandry


nikarc
 Share

This topic is 6580 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

This topic is 6580 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.