I have multiple data sources that dont all share common fields. I have created a link table to bring them all together and was planning to build a master calendar that links to it. I am running into trouble trying to get the data to filter correctly when you pick different dates.
Here is what I have
Link table:
Key_HospID*YearMonth
Key_LocationYearMonth
Key_LocationYearMonthDay
YearMonthDay
YearMonth
Since my master calendar isnt based on the data (fixed beginning and end date of today) I linked the master calendar on the YearMonthDay field.
Any suggestions for how I can link all my data so that it filters by dates the user picks?
