In order to be able to select a date and find the persons who have a specific value in one of the fields (Status, Home_Center, Person_Type) on that date, I created a [Master Calendar table], and a connecting table called [SubIntervals_x_Dates] based on the post by HIC : Creating Reference Dates for Intervals
[SubIntervals_x_Dates] has the columns:
This works fine.
Now I want to include a facts table called [Checkins] and link it to the other ones, so I am able to check who has a 'checkin' on a specific date, and what their 'Person_Type' was on that date.
[Checkins] has the columns
PersonID, Checkin_Date, Checkin_Center
I'm not sure how I can load my [Checkins] table in a way that it links to the master calendar, but doesn't link to the wrong persons or wrong dates.