ok finally would I still use the same database table structure if in the future I wanted to make one of the sidenav menu items to become one of the topnav menu items? The one way I can see this happening is physically copy the record in the sidenav to a new record in the topnav table....But I am sure thats a clumsy way of doing this process...unless if I have used the recordset you suggested all then the topnav and sidenav would work as one and then all I would do is for the top name display ALL record with a certain field value set to 1 and for the sidenav display all records with a field value set to 2 (for example). Would that be a better approach? Therefore in both tables I should create a field called "TopNavState" and in the sidenav create a field called "SideNavState" ..or am I not getting my logic messed up?
Chris