1 Reply Latest reply on Dec 18, 2010 11:14 AM by bumper

    Appointment booking



      Appointment booking



      How could I implement an appopintment system into my patient database so that I can see what appointments I have coming up and with which patient, and also be able to reflect the appointments that the patients have attended for within thier record.

      Thanks for any help on this one.

        • 1. Re: Appointment booking

          The simplest method is to create a "Schedule" table, with fields for the Date of Appointment, Time of Appointment and Patient ID (and Doctor ID if you have more than one doctor). You can then use filtered portals to display the schedule for a date, patients, doctors, etc. Just don't allow any of the records to be deleted. That way you can track missed appointments, etc.