Select a field auto select same value to other field

[gidon500]

hi all

Is it possible  to select a value a field  MONTH1

and same value will be selected to other field MONTH2

I need that when I select MONTH1 AS 6 , THEN MONTH2  WILL BE AUTO SELECT AS 6 AS WELL

THANKS

GIDON

[sunny_talwar]

Add a trigger on MONTH1 field where you use Select in Field trigger to set MONTH2 with the value =MONTH1

[sunny_talwar]

[gidon500]

HI

IT WORKS GREAT IF WE SELECT ONLY ONE VALUE

IF I SELECT 2 VALUES IT DOES NOT WORK

IS THERE SOLUTION FOR THIS PURPOSE

GIDON

[sunny_talwar]

You can use this in that case for Search String

='[' & Concat(MONTH1, |) & ']'

[gidon500]

HI SUN

TRIED IT , THERE IS AN ERROR

CAN YOU PLEASE PUT IT IN THE DOCUMNET TO SENT AT FIRST

THANKS YOU VERY MUCH FOR YOUR HELP

GIDON

[ecolomer]

Yes, see this example.

[jonathandienst]

Should be

='(' & Concat(MONTH1, '|') & ')'

[sunny_talwar · Accepted solution]

Sorry, you need parenthesis and not square brackets:

='(' & Concat(MONTH1, '|') & ')'

[gidon500]

THANKS

IT WORKS

GIDON