Multiple selections in another field

[vipingarg23]

Hi Team,

I have two listboxes. One is A and another one is also A but with alternate state test.

Here I want that If I select any value in A, it should automatically select that value in another one which contains alternate state. I applied a trigger and it is working fine for one value but not working for multiple value.

Please find the attached sample...

[tresesco · Accepted solution]

Use search string expression like:

='('&GetFieldSelections(A,'|')&')'

[sunny_talwar]

Try this for your trigger

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

[vipingarg23]

Excellent and thank you for your quick reply.

Both are working fine...Thanks a lot sunny and Tresesco for your help.