AnsweredAssumed Answered

Relating to a second table occurrence

Question asked by BradDuns on Dec 12, 2017
Latest reply on Dec 12, 2017 by BradDuns

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 it in an Event record. So I thought that I could create another occurrence of my MasterTable and make a relationship to just the date but that doesn't seem to be working.


I am trying to access it as a calculation in my MasterTable 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.