I am developing a system for a Church. I have a people registration table, however I need to relate this table to myself. I want to relate in this same table everyone who has any kinship and display a family screen.
Next: Register 6 people with them: A
, B
, C
, D
, E
and F
. Suddenly, I find that B
is the parent of E
. The person A
is coined of B
and prime of C
. How do I relate this?
The idea is when I select a person, to be able to list all the people connected to it. Father, mother, cousins, ... the difference is that everyone is on the same table.