Connecting From and To date to the master calender which is having only on field
Many of the tables in my document is having from and to date. I have master calender in the same document. I want to connect the date from master calender with all those tables which is having date in from and to range and both the fields are separately given.
Also If this is done then data should be filtered according to the selected date. For example, If I am selecting any dates which is in between from and to date. It should give all those details who are in that range. If I select the range of dates then it should give the result of all the values which falls under the selected range.
Also how to take care of synthetic key which may happen here.