One selection should also make a another selection in a different field/table

[ShellyG]

Dear all,

I need ideas on how to accomplish the following:

I have a filter, where the users can make a selection in a specific field. I want to make it in a way that when they make a selection, for example the selection is '2019' in field Year1, I want it to automatically select '2019' in Year2 field. 

There is a good reason why these fields are separate and I cannot combine them so that's not an option. 

Anyone has any ideas on how to do that? 

Thanks! 

[ShellyG]

In addition, the way that I imagine it working is as follows: 

If there is something selected in field Year1, then select the same in field Year2...

[ShellyG · Accepted solution]

Hi guys,

I managed to solve this one. In case someone needs something similar in the future - what you need to so is add in set analysis in your expression something like: 

Field1=P(Field2)

If it doesn't work at first, try switching the names of the fields. 'P' is for possible values of the specific field...