Thanks for your suggestion! I created a calculated column for Event Year in the target (Events Tracking) list. When I tried to set up connection by using this calculated column as both the provider and comsumer field, it didn't work.
If I create a new custom list to store event years, it might work. However, I don't want to manually maintain this list. Is there a way to keep these two lists in sync without manual intervention? Any suggestions will be greatly appreciated.
Thanks again for your help.