Notifications
Clear all
Topic starter
I am creating a report on a patient with the following information: Last, First, DOB, Address, Insurance informatino, and I need to list either the patients mother or fathers lastname and first name or their guardian's last and first name. I have searched all over and am unable to find any fields that give this information. I have found the guarantor's information but not parents or guardian's last, first names.
Posted : May 31, 2013 4:10 am
Are you using the table, RELPERS? I am not sure how/if it works. But you can try the field - RELATIONSHIP.
codes
PF Mother (parent, female)
PM Father (parent, male)
Hope this helps.
Posted : June 5, 2013 12:46 am
Topic starter
Thank you!!!!!
Posted : June 5, 2013 12:55 am
No Problem.
To get the parents' names:
Take RELPERS and two PERSON tables. Rename the second PERSON to PERSON_PARENTS
Links
PERSON.PID–>RELPERS.PID
RELPERS.PERID—>PERSON_PARENTS.PID
Record Selection
{RELPERS.RELATIONSHIP} in["PF","PM"]
Posted : June 5, 2013 1:06 am
