Originally Posted by Old Pedant
Ummm...from post #26:
Isn't that what I said? Really? Not quite sure what you are saying that is different.
I just finished updating post #36, so please check that out.
And, no, what you mentioned above in Post #26 is different.
You created a SECTION_SUBSECTION which doesn't work in the paradigm I want, because it completely bypasses the notion of a "Dimension". And thus, you could create a Section/SubSection pair like Finance/Litigation which would make no sense?!
(You can see how I fixed that issue in Post #31 without having a "Dimension" table.)
But since I want to keep my DIMENSION, I'm pretty sure that I am on to something in my last post (Post #36), however, please tell me what you think...