I am working on a relationship with a scheduling database.  

There is a MasterTable with all the events and each have a category.

My DateAndCategoryTable create a one line summary for records that match the day and category. The SummaryOutput is like 

Category A: 7:00a - 9:00p: Talk 1, Talk 2, Talk 3

 

My SummariesForDate table creates a list of all the summaries for records that match a date. The TextSummary is like 

Category A: 7:00a - 9:00p: Talk 1, Talk 2, Talk 3

Category B: 7:30a - 5:00p: Talk 4, Talk 5

Category C: 8:00a - 3:00p: Talk 6, Talk 7

 

I am trying to access that TextSummary in my MasterTable so I can display in an Event record. So I thought that I could create another occurrence of my MasterTable and make a relationship to the date but that doesn't seem to be working. 

I am trying to access it as a calculation in my MaserTable like this:

So I am wondering if there is something wrong with my relationship logic?

I am not sure what to search for either so thank you for any help or guidance.

Brad

 

Edited December 12, 20178 yr by BradDuns

This was solved by making a second occurrence of the SummariesForDate table and adding a relationship to the Main Master Table