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.

5a3031cae2742_ScreenShot2017-12-12at11_34_02AM.thumb.png.0cd67655dd92647d0554a2c9cae1c62d.png

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:

5a3038c9a99bd_ScreenShot2017-12-12at12_13_28PM.png.07ce017ceee881ebd0a0bab8aae21156.png

 

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

Outcomes