Jump to content

Relating to a second table occurrence


BradDuns

This topic is 2298 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 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:

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

 

Edited by BradDuns
Link to comment
Share on other sites

This topic is 2298 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.