Is there a way to achieve the following?
I have a table called people and a table called families. In the families table, I want three columns: mother, father, and children which are all linked to objects in the people table. In the people table i want just a single column which represents which family that person is in.
It seems like this should be pretty simple to do, but i can’t figure out how to get it to work without having multiple columns in the people table or splitting the people table into three separate tables. Any help would be appreciated.