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.

[Anil_Babu_Samineni]

Load * Inline [

Country, Population

India, 20

China, 30

UK, 40

US, 50

India, 60

];

Create two list boxes then Select India from Country and see how associative will happen

[sunny_talwar]

You can use triggers to get this done

Select in field Trigger for Population field with the following search string

'(' & Concat(DISTINCT Chr(34) & Population & Chr(34), '|') & ')'

[nachiket_shinde]

Hi Sunny,

   I have created the trigger but result is not as expected.

My output should look like

[sunny_talwar]

1) I don't see the field name you are triggering to -> Population here.

2) I think you are missing an equal sign before the expression I gave you

='(' & Concat(DISTINCT Chr(34) & Population & Chr(34), '|') & ')'

[settu_periasamy · Accepted solution]

Try this also..

Document Properties -> Field Event Trigger -> Add Actions ->

1. Clear Field - > Population

2. Select Possible -> Population

[nachiket_shinde]

Its not working

[nachiket_shinde]

Hi Settu,

   Its not working.

[sunny_talwar]

Is is possible to share the qvw you are working with?

[nachiket_shinde]

Hi Sunny,

   Please find file attached.