0 Replies Latest reply: May 4, 2015 10:11 AM by Chase Bushey RSS

    Link table and Master Calendar

    Chase Bushey

      Hi all,

       

      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?