after 20 hors reading and testing i found out that nobody actually created real XML (Webservice) Driven Navigation Bar with the Flex Accordion component.
This is ridiculous - 50% of the websites use vertical navigation bar as a main navigation and there is no easy way to create one with dynamic data.
I manage to create one but defiantly it is not the best and elegant solution - i call a webservice with a SQL SELECT to get a XML with the main categories and then on every show event for a specific category i call again the webservice with SQL to extract the subcategories for this exact category.
Please help me and all the other poor sols attempting to create decent navigation for their website.
below is sample DB structure for a standard navbar