Select in Field - Multiple Values Question

[#1]

When using a 'Select in field' trigger, if 1 or more values are selected in Field1 the desire is for Field2 to have the exact same selections everytime, how can this be done?  (I just need field2 to always = field1)

If just use =Field1 as the Search String it works fine with 1 value, but isn't working when 2 or more values in Field1 are selected.  

Thanks very much!

Richard

[#2]

Hi Gysbert,

Do you know if it would be possible to apply this technique if you were using the same field but alternate states?

So if both listboxes were for Name1Value but two alternate states?

=concat({[State1]} Name1Value) and listing the trigger for "State2" does work, but not for multiple selections.

Any ideas?

Cheers,

CG

[Chernov]

use double quotes, like this :

= '("' & concat({[State1]} Name1Value '" | "') & '')'

[bhanukoppera7491]

Hi Gysbert,

I do have same requirement but the problem I have been facing is my values have spaces in between. when I have spaces it's not selecting the value. Can you help me out, how to handle this situation.

Thanks,