Need a menu for navigating my forums

[RockFort]

I have different forums for different states/cities. In each state/city, I have the same set of subforums. E.g. Under California, I have chit chat, and classified and under New York, once again, I have NY chit chat and classifieds. To come to New York Chat, the user has to first click on Country, then State and then NY Chat. It gets a bit cumbersome to do that. So I was thinking of having a main menu with only the categories and when they click on the sub forum, then it lists all states/cities which have that sub forum.

I saw that there are some tools to create menus, but not sure if I need to buy that. Any suggestions how to make navigation easier in that setup?

Something like this. http://www.craigslist.com/about/cities.html with sub forums also included.

I have VBA CMPS installed, so I want to have this navigation as a separate module on the left or maybe a separate CMPS page.

Hope I am clear. Anybody have any suggestion to make navigation easier.

Thanks

[RockFort]

Bump. Anybody?

[Deaths]

This could be done, but I guess it would execute quite a lot of queries :/

[DeMiNe0]

it would take 1 query at most i think.. One to select all the forums..

The rest can be done by php i'm pretty sure. If i have time i'll work on this. I'm having some issues with my forum at the moment.