2 Replies Latest reply on Mar 18, 2012 7:57 AM by yourspoon

    one field, several entries

    yourspoon

      Hello!

       

      I like to create an database used by doctors to manage information about their patients. This database needs to look nice so I'm working with layouts.

       

      Since patients normally aren't sick for just one time in their lives, I need so use a table, that looks something like this:

       

       

      date
      age
      diagnose
      treatment
      18.01.201112flulots of fluids
      19.02.201213migrainepainkillers








       

      Hope you get the idea

      Is there a way, I can create a record like above? I already ask that question in another forum, but they told me, that it's not possible... but it seems to be very basic...

       

      Any ideas? I appreciate every helpt I can get!

        • 1. Re: one field, several entries
          comment

          The table should actually look more like this:

           

          VisitIDPatientIDDateDiagnosisTreatment
          1232518.01.2011flulots of fluids
          1242519.02.2012migrainepainkillers

           

          and it would be related to the table of Patients as:

           

          Patients::PatientID = Visits::PatientID

           

          If you place a portal to Visits on a layout of Patients, you'll be able to create new visits directly by entering them into the first empty row of the portal (provided you enable this in the definition of the relationship).

           

          All of this is pretty basic stuff and very far from impossible. Note that the age of a patient at the time of a visit can be calculated from the visit's date and the patient's date-of-birth (stored in the Patients table).

          • 2. Re: one field, several entries
            yourspoon

            and THAT'S how the magic works! Thank you SO much!