Dear All,
I have 3 table one is tblSubMenu1,tblSubMenu2,tblSubMenu2Options. So for now I have a combo with all the tblSubMenu1 value in it. Then upon selection any of the value in my combo box will appear all those tblSubMenu2 column subMenu2Name value and together with a checkbox column. So together I have another combo box for employee. So I can assign the subMenu2Name accordingly to the employee. My problem now comes is that with tblSubMenu2Options which are linked to tblSubMenu2. So for some employee I need to select the options which also need to be assigned together with tblSubMenu2 values. What is the best way I can represent my problem? Thank you.
I have 3 table one is tblSubMenu1,tblSubMenu2,tblSubMenu2Options. So for now I have a combo with all the tblSubMenu1 value in it. Then upon selection any of the value in my combo box will appear all those tblSubMenu2 column subMenu2Name value and together with a checkbox column. So together I have another combo box for employee. So I can assign the subMenu2Name accordingly to the employee. My problem now comes is that with tblSubMenu2Options which are linked to tblSubMenu2. So for some employee I need to select the options which also need to be assigned together with tblSubMenu2 values. What is the best way I can represent my problem? Thank you.