Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm a bit frustrated because of my problem.
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.
Anyone has got an idea how to deal with it?
Thanks a lot!
Got my own solution.
I added a hole Calender to the linkage table of all dates. Now I have got the structure :
all dates -> every kind of date
Now I can choose the year at all dates and can show the different kind of things in the other tables.