That's a great solution - Unfortunately, it does not appear to work for multiple text values. If I select a single value in the trigger field, it selects the corresponding value in the other fields (I need it to select in two other fields). However, if I select multiple values in the trigger field, I get no selections at all in the other two fields. Any idea how to fix this?
I used your solution for a month to fiscal period trigger and it works great. However when I select more than six months it turns from the periods selected to NOT the periods that I did not select which makes the trigger ineffective. Any idea why this occurs, and a way that I can correct it? Any further help you can offer on this will be greatly appreciated.