Help Setting Up Appointment Sceduling

[tfayer]

Does anyone have any suggestions for setting up an appointment schedular? One Idea I had is as follows:

tblDate with Date Field(PK) populated by Function to x Years in the future as ShortDate

tblTime with Time Field(PK) populated on 15min intervals for 24hr Day as SWhortDate, and Date Field populated with all dates from tblDates for every 15min Interval in Time Field

tblAppointment with AppointmentID Filed(PK) populated with every combination of Date & Time

This would create an enormous amount of records.

Anyone have suggestions?

Thanks

 

[dynamictiger]

I have a works schedule application, that takes a different approach I have:

WorkerID
StartTime
EndTIme

ClientID
ClientEtc

ScheduleID
ClientID
Date
BeginningTime
Duration
WorkerID

The begin time cannot be less than the start time, the begintime and duration cannot be greater than the endtime, etc. There is no set schedule as the appointments become self generating.

HTH