I want to be able to fill in the day events for each resource listed. Here is what I have so far . . .

LOB 101
LOB 102
LOB 103
etc.

After loading the resources (i.e., rooms), I want to go back and populate events for each room such as . . .

January
24 25 26
LOB 101 Meeting 1 Meeting 2 Meeting 3
LOB 102 Meeting 4

How can I iterate through the list of resources, get the events for each resource and display them as above. Unfortunately, the way the database was designed it does not have a one to many relationship between resource and events..

Thanks.