Populating dialog list based on the value of another dialog list

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

Subject: Populating dialog list based on the value of another dialog list

Is @DbLookup(“”:“Nocache”;“”;viewname;value1;2) what you are looking for values of dialog list2 ?

Subject: RE: Populating dialog list based on the value of another dialog list

Thanks for your response Thierry.