I am handling different kinds of visits so there are a lot of date-fields in my application. Because I have different management ratios I need to have a calender-table for each of the fields. If I have just one master-calender (and I had it...) some of the ratios are summed up twice (new year = 2 years and double counting) so I decided to split the calenders.
My problem is now that I want to select a year and show all the values. Now that I have more than one year-field I don't know how to do that because when I select the start-year, the endyears are not possible values any more.