Years ago I did already developed a calendar for appointments for 4 different specialists. It is bases on a single Table with many repeating fields: for each specialist there is one repeating field for work hours, one for client name, one for duration of appointment, one for reason of appointment.
It works fine but I hate repeating fields and the relationship graph looks like a monster.
I am looking for a more "creative" way for designing a new appointments solution based... I would guess on portals.
In this case I would have at least 3 Tables: one for Work hours for each specialist, one for Days, and one for Clients.
I though it was just easy but I am stuck in combining all information together inside one Portal, or, at least one Portal for each Specialist.
Any suggestion ?