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