AnsweredAssumed Answered

Table Relationship for Calendar

Question asked by CharlieBecker on Feb 26, 2015
Latest reply on Feb 27, 2015 by philmodjunk

Title

Table Relationship for Calendar

Post

I've got a tricky table relationship question.  I'm developing a calendar layout.  I have an Events table with 2 records with StartTime and EndTime and I have a "CalendarHours" table with 24 records (one for each hour).  I want to create a relationship like the following:

Event1 StartTime = 4am  EndTime = 6am
Event2 StartTime = 5am  EndTime = 6am
Event3 StartTime = 8am  EndTime = 9am

I want my resulting table to have 24 records, the 4am record should have a list field containing Event1, the 5am record should have a list field containing Event1,Event2 and the 8am record should have a list field containing Event3.

I've done lots of simple relationships before but have no idea where to begin on this one.

Thanks for your help!

Charlie

Outcomes