Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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), '|') & ')'
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.
settu_periasamy's suggestion is working perfectly. PFA
Yes Sunny,
Its working correctly. I must have made some mistake in implementing.
Thanks for your efforts.
I am glad you ultimately found the solution you were looking for.
Best,
Sunny