Patient Table to include Parent(s) as responsible party and a patient.
Patient Table to include Parent(s) as responsible party and a patient.
(OP)
I have a patient table which includes names, dob, sex, etc.
Of course patients could be adults; children and dependent adults.
I want to be able to have all these people in one table; but also want to be able to identify Jane Doe as a parent of Bobby Doe. At the same time Jane Doe is also a patient.
So this is what I have. tblPatient (last name; first name, etc for fields)
I could make a table: tblParent but I don't want to store duplicate names..
That is where I am stuck with a mind block (I think I am overthinking again and can't see the nose in front of my face).
If anyone could steer me in the right direction, would greatly appreciate it.
Thanks!
Of course patients could be adults; children and dependent adults.
I want to be able to have all these people in one table; but also want to be able to identify Jane Doe as a parent of Bobby Doe. At the same time Jane Doe is also a patient.
So this is what I have. tblPatient (last name; first name, etc for fields)
I could make a table: tblParent but I don't want to store duplicate names..
That is where I am stuck with a mind block (I think I am overthinking again and can't see the nose in front of my face).
If anyone could steer me in the right direction, would greatly appreciate it.
Thanks!
RE: Patient Table to include Parent(s) as responsible party and a patient.
One way to do it would be to have a structure like this:
So your Relations (Rel) table would be something like:
Grp field would indicate the Group of people for that Patient (including the Patient)
---- Andy
There is a great need for a sarcasm font.
RE: Patient Table to include Parent(s) as responsible party and a patient.
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
RE: Patient Table to include Parent(s) as responsible party and a patient.
prePReID prePatientID preRelPatientID preRelationID
1 1 2 Mother
2 1 3 Father
3 6 2 Mother
4 6 3 Father
I doubt you would need it but you could show kid relations
5 1 6 Brother
6 6 1 Sister
Now making a form to do this may be a little tricky and you would need to come back. You have what is called a 1 to many self referencing table, and that is not done very often but it is doable.