Originally Posted by Old Pedant
Ummm...it probably does.
But don't despair. It just means that your business model isn't correct. And you need to adjust it. It doesn't impact the derived vs. natural keys decision. It doesn't impact your idea of having a hidden "dimension" that sits outside the perceived navigation.
Just keep working on it until you are truly happy with the model.
I guess that means, "Go back to your drawing board and take another swing at it (and then maybe I can help)..."
Except, my brain is pretty fried on this entire undertaking...
I will go back and try to figure out how to fix things, but I'm praying I can still get some help, because I feel like this is pushing me beyond my capabilities, and it is also stopping my entire website development dead in its tracks...