I have 3 table let say table1 ,table2 and table3
Table1 with 2 columns pid and productname
pid(P.k) productname
1 abc
2 qwe
3 ewre
4 jui
Table2 with 2 columns fid and imagename
fid(P.k) imagename
1 a
2 b
3 c
4 d
5 e
6 f
7 g
8 h
9 i
Table3 with 3 column name id pid whick is foreign key and fid with foreign key of table1 and table2 respectively
id pid(F.k) fid(F.k)
1 1 1
2 1 4
3 1 6
4 1 8
5 2. 2
6 2 4
here is my tables which is made on inserting the items of pid
here i want to get all values of table2 in datalist with empty checkbox and at the same time i want to get checkboxsign as tick whose value of fid is asigned in table3 of an particular product pid.
I know that my explanation is not good than also please suggest that how i used to explain.
In advance thankyou to reply me.