Default selection on listbox on selection in other listbox

[nachiket_shinde]

Hello Experts,

     Suppose I load following table

Country	Population
India	20
China	30
UK	40
US	50
India	60

Now I have two list boxes 'Country' and 'Population'.

Requirement:

If I select Country 'India' then two associated values in Population should be green by default.

This should happen to all the values in Country.

How to do this?

Note: I am working on Personal edition so QVWs won't work for me.

Thanks in advance.

[sunny_talwar]

I think you were adding a trigger to Population field, when in fact you needed to add one to the Country field.

I added two actions

1) Clear Field -> Population

2) Select in Field -> Population

    Search String -> ='(' & Concat(DISTINCT Chr(34) & Population & Chr(34), '|') & ')' 

[nachiket_shinde]

Sunny,

  Its working fine for first selection. But if I try to change selection it is giving strange results.

   It sometime shows associative values or sometimes it selects previous result. 

  Before selecting any other value in country field I have to clear fields.

[sunny_talwar]

settu_periasamy‌'s suggestion is working perfectly. PFA

[nachiket_shinde]

Yes Sunny,

  Its working correctly. I must have made some mistake in implementing.

Thanks for your efforts.

[sunny_talwar]

I am glad you ultimately found the solution you were looking for.

Best,

Sunny