I am trying to set up some tables in Acess to do the
following:
The scenario is this:
A person visits the hospital. On the first visit they
are assigned a medical record number that is their
unique identifier. (sort of like a social security
number)
Each time after that they come in, they get a visit
number so they can have many visit numbers depending
on how much they come in.
Also the doctors can order one, many or not test done
so the order field could repeat.
I have the folling other fields that i will put in the
table
patient name
birthdate
date of the first visit
visit date (date of a particular visit)
doctor (the doc that saw them at the visit)
order description (what they had done ex-blood work)
