Large multi week calendar

[Andrew Robinson]

We have a table containing time bookings for all of our staff. Its the data for a calendar so has: Name, Start Date, End Date, Start Time, End Time, Description. We also have a table which is just the names of the people.

We have a week planner view which I made by 7 relationships and portals, works reasonably well, apart from if you are viewing quite a few peoples records at the same time it takes some time to update.

I have 2 Questions:

1. Is there a slicker way than having 7 portals? The blocks do not join up with each other. (See Example)
2. Our business want to make a much bigger view that shows 3 months at a time, for each person. Imagine the data lookup! Does anyone have any experience in making large calendar views and how you would go about it.