Table Relationship for Calendar
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!