i may not explain my problem clearly but bellow i written with description..
Actually i am having to check box lists(check-box list1,check-box list2)
for check-box list1 i am binding all the users(registration_id) from registration(registration_id,name,login_id,password) table and for check-box list2 i am binding the records from access table(access_id,description,status) where the records are in static means in that table i am having six records those records are static.
now both the check box lists are displaying on my webpage.
and i am having one more table user_access in that table i am having three fields(registration_id,access_id,status)
example:
//i inserted one record in registration table
------------------------------------------------------------------------------
registration_id | username | loginid | password ------------------------------------------------------------------------------
1 | nitish | ab@gmail.com | 12345
access table(static)
-------------------------------------------------------------------------------
access_id | description | active
-------------------------------------------------------------------------------
1 | reports | 1
2 | leads | 1
3 | import | 1
user_access table (while registration only these records will inserted by taking registration_id from registration table and access_id,active from access table)
------------------------------------------------------------------------------
registration_id | access_id | active
---------------------------------------------------------------------------------
1 | 1 | 1
1 | 2 | 1
1 | 3 | 1
here what i want is when i binded all the users in check-box list1. if i click on any particular user it should check the user_access table whether that user having the active 1 or 0, if it is 1 means check box should be checked in check-list 2 where we already binded the records from access table