What are your slot time period. One day each or are the time periods
smaller than a day. Is what you looking for something like this


10/1/09 9:00 AM
10/1/09 10:00 AM
10/1/09 11:00 AM
10/1/09 12:00 PM
10/1/09 1:00 PM
10/1/09 2:00 PM
10/1/09 3:00 PM
10/1/09 4:00 PM
10/1/09 5:00 PM
10/2/09 9:00 AM
10/2/09 10:00 AM
10/2/09 11:00 AM
10/2/09 12:00 PM
10/2/09 1:00 PM
10/2/09 2:00 PM
10/2/09 3:00 PM
10/2/09 4:00 PM
10/2/09 5:00 PM
10/3/09 9:00 AM
10/3/09 10:00 AM
10/3/09 11:00 AM
10/3/09 12:00 PM
10/3/09 1:00 PM
10/3/09 2:00 PM
10/3/09 3:00 PM
10/3/09 4:00 PM
10/3/09 5:00 PM


Then you hav appointments like this in a second table
10/2/09 9:00 AM 2 hours long
10/3/09 10:00 AM 1 hours long
10/1/09 1:00 PM 3 hours long

And then you want to indicate in the first table which appointments are
filled?


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=148336