Hi all:
I am a relatively new user and grids have frustrated me so far!
Briefly, I am writing an appointment scheduling module for professionals. The tables I have created are:
- Professionals
- Appointments
- Timeslots (15 min units)
- Clients
The form I have desigined so far (to browse appointments and identify empty timeslots), has a base class combobox, set to style 2 which will be populated with the full name of the professional. I also have on the form the olecontrol calendar. Addtionally, I have placed the base class grid on the form with 8 columns. The first col header is titled "Time" and the other 7 columns will have dates displayed as characters.
I have also created a cursor that joins the timeslots table and the appointments table.
The objective is to populate the grid with client appointments based on the professional chosen in the combobox.
What I am struggling with is trying to find a way of displaying the client's name in the proper column which shows the date as a character field, while at the same time, displaying the name in the proper timeslot that the appointment had been made for. This should be repeated for any doctor chosen as well as when the next 7 days are chosen to be viewed. My plan is to have the user double click in any free timeslot in the grid which will then bring up an appointment booking form.
Would appreciate your advise on how I should proceed with this problem.
Thanks folks. Any help will be appreciated.
- Ravi
- Ravi
True greatness consists in being great in little things.
- Charles Simmons