Henry,
Don't know if this will be of any help, but anyway…
I've found it easier to use a temporary cursor (maybe this is what you're using) for displaying and editing scheduling data, where the cursor is designed to match the visual presentation of the data. I then move the data from the temporary cursor to the ordinary tables when appropriate. For example, I have scheduling data stored as FromDate, ToDate, FromTime and ToTime (the last two as seconds since midnight), but in the temporary cursor, which is the source for the grid, I build this as a text string in a time format (HH:MM-HH:MM). My datamanager takes care of translating the data back and forth.
I also like the controls from Dbi Tech (
www.dbi-tech.com) a lot. They have controls that are designed for scenarios like this.
In a system I'm working on now, the user can choose different ways of entering the data, either by using Dbi's scheduling control (ctSchedule.ocx), or by typing time data in a grid.
I've taken some snapshots if you're interested:
http://www.lexi.no/bilder/stpics.htmJens Erik
>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
