I have set up a database from which I am creating a large number of pages using a dynamic page template.
The database includes a column for Categories (for now I have 4 Catagories) and a column of Topics, which are a subset of the Catagories. Each topic represents a website page.
I am ultimately trying to setup a dynamic Menu for my website which updates each time I ad a new Category and or Topics to my database.
I would like each Category to appear as the main menu and then when I hover the mouse over the menu I want each of Topics to be available for selection sitting underneath their associated Category.
To try and achieve this I was thinking of making a lightbox menu into which I embed a table. I was hoping to be able to connect the column headers to the Categories of my database, and then the table rows to connect to the associated Catagoy Topics. Effectively creating a 'repeater' which is dynamic in both rows and columns at the same time. However it doesn't appear tables are able to be set up in such a way.
Are you able to assist me with this?