Table structure for Menu

[[gja]]

Hi There,

I need a little help here on how to structure my menu to be place on my Mainform.
i placed my menu logic on the database(e.g File,View,Edit,Report etc.).So that if my mainform is loaded it automatically populates menu on the menubar and also populate sub-items in the menu (e.g File --> Option etc. straight down).

My Current Table Structure
SystemUserMenu table
ID RoleCode ModuleCode MenuName MenuIndex
1 , Administrator , File , Option , 1


SystemMenu table
ID ModuleCode MenuName DisplayName
1 , File , Option , My Option


.my problem is how can i structure my table if there is a sub-items "Find" in the Option sub-items.something like "parent" and "child" implementations.

Example:
File
--Option
---Find

Thanks in advance.
glen

[jmcilhinney]

Your table should have an ID column and a ParentID column. This table:

ID  Text     ParentID
1   File
2   Project  1
3   New      2
4   Open     2

would then create this menu:

File
    |
    Project
        |
        New
        |
        Open