Trigger the values in one field with selection in another field

[avinashkk696]

Hello Experts,

I have a requirement in which I have two list boxes (Or Say Fields) which has no Association between them. My requirement is, when I select multiple values in one list box, the same values should be selected in the other list box also.  Below is the sample code. On selection of multiple "Countries", I want same values to be selected in the "Area".

Note: I want it using triggers only. I don't want to have any association between them.

Country:
LOAD * INLINE [
Country
India
Pak
Zimb
SA
USA
NL
CHINA
CAN
];


Area:
LOAD * INLINE [
Area
India
Pak
Zimb
SA
USA
NL
CHINA
CAN
];

Thanks In Advance.

Please find the QVW for the reference.

[sunny_talwar]

But my question remains, why do you need the if statement, why can't you just use this?

='("'&Concat( DISTINCT Area,'"|"')&'")'

This should always give the same result as the if statement you are using right now

[Anonymous]

@Sachin,

=GetFieldSelections(Country) works only for one country, if I select multiple countries it is not reflecting in the other list box.

[sdmech81]

HI,

U missed the above discussion..Go through tht,I have mentioned something above fr tht I guess.

I thought u need only this much..Create new thread,this tread is marked as done so tht u receive better answers.

Sachin