nested dynamic menus
Hi I wanted to do a 2 nested dynamic menu for product categories. (Product Categories > SubCategory1 > SubCategory2).
Im using my existing database structure. currently I have a products table witch stores the ID of the main category and and ID of a subcategory (this was for a previous project).
Im trying to following the WebAssist tutorials - and Im wondering when the tutorial is refering to the "items" and "itemcategories" tables im assumning i can relate to my database as my database is "products" (this stores the ID for both categories and subsategories" and my second table "categories" but i did create a third table a while back called "subcategories" and this has a reference to the categories table.
all i require is my client to be able to have 2 subcategories from the main categories - now im just want to get an idea of the most logical table setup.