AnsweredAssumed Answered

Portal from different Tables

Question asked by Wicktor on Dec 10, 2016
Latest reply on Dec 29, 2016 by philmodjunk

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 ?

Victor

Outcomes