I need to have a table of appointment types. The following is an example of what that table could look like. I'm having a hard time coming up with the best way for the user to select the various values though. I would like to use a calendar for the dates. Not sure about the times. I'm also going to use a picklist for the RGB codes (these won't be seen by the user, just the color picker). Just looking for suggestions on how to present this. They will need to be able to see all the rows/records and add/delete/edit. Any suggestions welcome. The simpler the better, but I want it to have a bit of a slick look. I already have a nice color picker to use, and I know I can use the calendar OCX, but how best to give it all to them to select? Thanks!
APPTTYPE RED GREEN BLUE STARTDATE STARTTIME ENDDATE ENDTIME DOW
New Patient 0 0 255 12/18/07 09:00:00 AM 12/18/08 12:00:00 PM 2
New Patient 0 0 255 12/18/07 02:00:00 AM 12/18/08 12:00:00 PM 3
Follow Up 0 255 0 12/18/07 09:00:00 AM 12/18/08 12:00:00 PM 4
Nurse Visit 255 0 0 12/18/07 02:00:00 PM 12/18/08 05:00:00 PM 2
Nurse Visit 255 0 0 12/18/07 02:00:00 PM 12/18/08 05:00:00 PM 4
Nurse Visit 255 0 0 12/18/07 02:00:00 PM 12/18/08 05:00:00 PM 6
Surgery 0 255 255 12/18/07 09:00:00 AM 12/18/08 12:00:00 PM 5
Lab 0 0 255 12/18/07 09:00:00 AM 12/18/08 12:00:00 PM 6
Annual Physical 255 255 0 12/18/07 09:00:00 AM 12/18/08 12:00:00 PM 7