Hi All,
I have 2 dialog list and I am populating these by using DbLookup.I have created a view and doing DbLookup based on the column values(dialog list 1 getting value from column 1 and dialog list 2 getting value from column 2).
So far so good. Now coulmn 1 has values say A , B , C and column 2 has values A1, A2 , B1, B2, C1, C2. Now my problem is how to show values in dialog list 2 based on value in dialog list 1.
For example if user select A in dialog list 1 then I have to show only A1 and A2 in dialog list 2.
In the view the values in column are as shown below:
Column 1 Column 2
A A1
A A2
B B1
B B2
C C1
C C2
Thanks a lot in advace.
P T