Thanks for the example. I had read all the support & forum content, and I'm convinced this is exactly the format I have got set up.
For itemscategories table, I am using a table called nav1
- for fields CatID, CatName
- I am using fields id, text1
every page is a category eg home page is cat1 / about cat2 / contact cat3 etc
For items table I am using a nav2 table
- for fields itemsID, ItemsCatID, ItemsName
- I am using id, page1, text1
I have inserted duplicate columns into my tables using the same field names as in the example. I have set all the items ItemCatID to 2 (so that they all appear under one menu only) but still don't get a secondary menus.
This is a link to the under construction site (built using sculptor).
_page1.php ... _page1.php
- the home page link is the nested attempt
- all other page links are using a menu with no nesting.
On the un-nested menus all the sub menus show on all the rollovers (which is what I expected considering no filtering etc). It's pulling up the correct available links. Attempts to spread across the links as per the item categories on the home page link the nested version.
I honestly don't think I've got the cross referencing wrong, because when I open the recordset up and test/edit the default value in dreamweaver I get the correct results. I've also double checked the database number fields are all int inputs, not varchar !
The wizard configs are as per the screen print in original posting.
I'm sure it's something very simple that I'm missing, could you look at my example link and if you need copies of any of files lets me know.