Hi, In my project there is a page which contains a select box and checkboxes. The checkboxes are the permissions to be assigned.So for checkboxes there are some corresponding names.There are parent names and also the child names.For parent names the checkbox should be readonly.If the corresponding child checkbox is selected the parent should automatically be selected.

My database table structure is as follows: CREATE TABLE "MENU" ( "MENU_NAME" VARCHAR2(4000) NOT NULL ENABLE, "PARENT_ID" NUMBER, "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "URL" VARCHAR2(4000), "MENU_ID" NUMBER NOT NULL ENABLE, PRIMARY KEY ("MENU_ID") ENABLE, CONSTRAINT "MENUIDFK" FOREIGN KEY ("MENU_ID") REFERENCES "MENU" ("MENU_ID") ENABLE ) /

For child of particular menu the menuid of parent will be the parentid for submenu and url for all the parent url is null. The checkbox values are to be inserted into the following table: CREATE TABLE "ROLE_MENU" ( "CREATED_ON" DATE, "CREATED_BY" VARCHAR2(4000), "MODIFIED_ON" DATE, "MODIFIED_BY" VARCHAR2(4000), "MENU_ID" NUMBER, "RL_INS" NUMBER NOT NULL ENABLE, "RMID" NUMBER, "ROLE_ID" NUMBER NOT NULL ENABLE, CONSTRAINT "ROLEMENUPK" PRIMARY KEY ("RMID") ENABLE, CONSTRAINT "FKMENUID" FOREIGN KEY ("MENUID") REFERENCES "MENU" ("MENU_ID") ENABLE, CONSTRAINT "ROLEMENUCON" FOREIGN KEY ("ROLE_ID") REFERENCES "ROLE" ("ROLE_ID") ENABLE ) /

the checkbox values which are selected rl_ins=1 and not selected rl_ins=0. Please send this as soon as possible.

Thanks in advance, Premika