I am starting a new project which will be a registration site for health screenings and would like some thoughts on the best way to achieve the following:
Once a user logs in they must complete a form consisting of basic contact information. The also need to select the appointment time they want from a list of available options. Those are:
Drop downs:
Day: Monday-Friday
Time: 8:00 am - 5:00 pm
What I need to do is have the times that are already selected by someone else, not show up in the drop down list. Same thing for the day. If all times for a day are taken, that day does not show as an option in the drop down.
An additional caveat is that a user can come back and reschedule, effectively releasing that Day/Time for use by another user.
Your thoughts and direction are greatly appreciated.
