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

    Appointment booking

    alex4478

      Title

      Appointment booking

      Post

      Hi,

      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
          bumper

          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.