Family Relationships Location in Database

For users or potential users.
Post Reply
smiliestech
Posts: 5
Joined: Wed Jul 27, 2016 7:13 am

Family Relationships Location in Database

Post by smiliestech » Thu Aug 18, 2016 7:29 am

I'm trying to write a query to determine which patients do not have a parent listed in their family. However, I can't locate the family relationships in the database--that is, the database equivalent of the "Family Relationships" box in the Patient Information window. Does this information exist in the database, and if so, where? Thanks.
Top
User avatar
jsalmon
Posts: 1557
Joined: Tue Nov 30, 2010 12:33 pm
Contact:
Contact jsalmon

Re: Family Relationships Location in Database

Post by jsalmon » Thu Aug 18, 2016 9:00 am

In the guardian table:
http://www.opendental.com/OpenDentalDoc ... l#guardian
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com
Top
Post Reply

Return to “Main Forum”