Hi All,
I'm trying to design tables for building a navigation menu for a web app. I'm torn between doing it all in one table as a hierarchy, or in multiple tables using a "main category", "subcategory", "subsubcat" , etc. and relating them though a "menu_items" table saying which category and sub category, etc.
The thing is i need to send the menu to the web app in XML, so just trying to figure out which design would make the creation of the XML doc easiest.
Any suggestiosn would begreat...
Thanks
Keith
I'm trying to design tables for building a navigation menu for a web app. I'm torn between doing it all in one table as a hierarchy, or in multiple tables using a "main category", "subcategory", "subsubcat" , etc. and relating them though a "menu_items" table saying which category and sub category, etc.
The thing is i need to send the menu to the web app in XML, so just trying to figure out which design would make the creation of the XML doc easiest.
Any suggestiosn would begreat...
Thanks
Keith