INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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!

RE: Patient Table to include Parent(s) as responsible party and a patient.

"I want to be able to have all these people in one table"

One way to do it would be to have a structure like this:

PK  Grp Rel FName  LName DOB  Gender
1    1   1
2    1   2
3    1   2
4    2   1
5    2   2
6    2   3 

So your Relations (Rel) table would be something like:
PK   Who
1    Patient
2    Parent
3    Uncle 

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.

I would create a junction table that allows for multiple adults

PatientRelationships
prePReID          autonumber primary key
prePatientID      from the patient table
preRelPatientID   related parent or other from the patient table
preRelationID     link to table Andy suggested 

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: Patient Table to include Parent(s) as responsible party and a patient.

I do not think "Patient" would go in the relationship table. I think if all people, patients or relations go in the main table then that would be a boolean field. A person is either a patient or not. Then do as Duane describes. So if patient 1, has a mother with ID of 2, and Father with ID of 3 in the main table. And if patient 1 had a sibling 6 then it would look like this.

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close