Select multiple values based on selection 1 to many

[nam]

Hi can someone help me with my scenario to create the best, quickest Method to achieve this

I have 2 fields Field A   and Field B

when selecting 1 value in Field A I get many values in (White) associated in Field B

What I want to do is if I select 1 value in Field A I want the multiple values to be selected as (green) rather then associated(white).

Please share your comments or examples on how this can be achieved quickly

[JonnyPoole · Accepted solution]

In the document properties go to triggers.

Under Field Event Triggers , highlight field A and add a 'on select' action.

Add an action of type Select -> Select in field

enter  [Field B] for the field and the following for the search mask:

='("' & concat( distinct [Field B], '"|"') & '")'

Below you can see me doing this for a field called Country instead of [Field B]

[maxgro]

PFA