Hey everyone,
This may be a stupid question, but I've kind of hit a brick wall. I have a database that I'm creating with the sole purpose of alphabetizing an entire glossary. How the glossary will appear is it will start with Sections, then list Subsections below the Sections. However, some (not all) Subsections will have Subparts. There are (of course) 3 tables: tblSections, tblSubsections, and tblSubparts. Here is what the relationships look like:
Now, creating a query for just the Sections and Subsections works just fine for the report; it lists each section in alphabetical order, then the subsections as well. However, when I start adding cells from the Subparts table to the query, the query begins to... freak out (so to speak). I'm scratching my head at this point, and it's probably a simple solution, but I just can't seem to think of one.
My end goal is to have the report list out Sections, Subsections, and for some of the entries, Subparts. Any ideas? Here is the link for the .db file (It's 540kb, just 40 kb over the limit for Access Forums). https://drive.google.com/file/d/0B-i...cwTzVUQ2M/view