Hello everyone!
I have 3 questions regarding our patient database for a study. Sadly my personal effort could not help me any further.
We have a multitude of patients which have their patient ID as their primary key in an initial form.
Second, there is an examination form which is filled out several times at different times for each patient. And examination date is a field in this form. And these two forms are linked by patient ID.
1) My first question: How do I make a drop-down list of all examination dates on the examination form of a patient? (so that when I open the examination form of that patient, all other examination dates are seen on the drop-down list)
2) How do I link these examination dates to the examination forms? (So that the form belonging to that date comes up when I click on the date)
3) When I open an examination form of a patient, how should I form a macro so that a button moves to previous or later forms of that specific patient (to move through previous and subsequent records of that one specific individual)?
Thank you very much in advance.