Show all possible records on form 'on open'

[mapondera]

I want a 'doctor's appointments' form in my database. It must show all the possible times for a given day that a doctor is available. The times are in 15 minute increments between 9 a.m. and 3 p.m. I want my form to show all of these time slots at once, and then the database user can fill in the 'patients name' and 'visit purpose' fields for each time slot. Patients may not necessarily pick appointments with one straight after the other. This is why I want all the times to show up at once. How do I do this?

e.g.
Start Time Patient Name Visit Purpose
09:00 a.m. Mr. Reynolds General Checkup
09:15 a.m.
09:30 a.m.
09:45 a.m.
10:00 a.m. Ms. K. Smith Vaccination
10:15 a.m. J. Tedesco Sprained Ankle
10:30 a.m. J. Tedesco Sprained Ankle
10:45 a.m.
etc. up 3 p.m.

 

[RichMorrison]

I made a similar application to schedule conference rooms.

1) Make a table with a row for each time slot. The first column will be date, the second will be the time range, and the third will be a text field for patient name.

2) Populate the table with rows for all the dates and times you need. The patient name will be empty. I did this with code.

3) Make a continuous form based on the table.

Short answer, approach does work.

RichM