Here is a possible solution. Use a cartesian product query when a new day is selected to auto populate the records. Here is the SQL statement I created and it works like a champ.
INSERT INTO tblAppointmentDateDetails ( AppointmentDayID, AppointmentTime )
SELECT tblAppointmentDates.AppointmentDayID, tblTime.Time
FROM tblTime, tblAppointmentDates
tblTime is a table that contains a single text field. each record contains a time. Notice that in the from clause, there is no join. This is what makes it a cartesian product. Make sure you use the where clause to specify a date. Otherwise you will be creating 67 records for each day in the database.
Hope this helps,