>The problem solved by Selecting appointment table... still try to debug... at this stage, it works fine!
Last time I did appointments, I have set the number of appointments per day (where each location had a day length set - could be anywhere between 2 and 20 hours, depending on the staff), and then I created so many time slots. There was no double booking in the sense that the doctor couldn't have more than one patient at a time. However, one appointment could take more than one slot.
So each time the appointment form came up, I'd pull up a browse window (2.6 DOS then) with all the slots, the taken ones being read-only, but movable or deletable. I just forbid overwriting them. And, didn't really save the unused slots - when the form was pulled up again, I'd create the empty cursor again and fill the saved slots.
From your code I see you've taken a different approach - just wanted to see the exchange rate of 0.02 dinars (i.e. 2 para) vs yuans :).