multiple , similar assessments of a patient over time.
I am a doctor with a database of about 120 patients who have had annual assessments over 5 to 10 years. The assessments measure the same parameters and I need a simple way of creating this in a FMP database.
The assessments are few and very simple – alive or dead – had a treatment didn't have treatment, disease control disease not controlled. These assessments are the same each year. Having fields that say
alive / dead year1
Alive / dead year2
Alive / dead year3
Etc seems the easiest way. Is there a better way ?.