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
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?