Right now it isn't displaying anything but the main categories.
The hierarchy is:
Products (main menu link to be hovered over)
---Main Category (displays main categories)
When I was making the nested sub categories, my settings were as follows:
New dynamic link
SubCategoryMainCategory (Nested Filter)
SubCategoryName (ascending sort)
So I added the repeat region to visually see what subcategories are in which main categories and I get this (i only added "Earrings" in main category "Jewelry":
Sub Category: Earrings in Main Cat: Beads
Sub Category: Earrings in Main Cat: Jewelry
Sub Category: Earrings in Main Cat: Tools
Sub Category: Earrings in Main Cat: Step-By-Step Books
Sub Category: Earrings in Main Cat: How-To DVD's
I look in the database via phpmyadmin and the subcategory Earrings has a SubCategroyMainCategoryID of 2, which i then checked, and it is Jewelry.
So the menu is to show as you typed, then and you have all the 3 tables. Relation made to the product table also?
If i understod it right, when u put in earrings in as a Sub Cat in Main Cat Jewelry, it shows up in all main categories when you put a reapeat region on? But in phpAdmin it just shows 1 for that main cat and thats Jewelry then sub cat Earrings?