I am trying to work this out, maybe someone can offer some expert advice?
In one table, I have all people who are related to our organization.
One way that we define who they are is by establishing the relationship between two (or more) people. We identify “Child, Spouse, Parent, and Sibling” as members who you can identify or link to directly.
Here is the issue though, and I will give it in an example.
E.G. We are recording a new student, and in the “Parents” the student goes to list his parents. But, the student cannot find their parents because they are not in our records at all. If we stopped and created a new record for the parents, then we have a problem of recording “Spouses” and “Children” at the time of creation of the record. Other programs we’ve used have allowed us to add a similar record within the creation of another record and creates the link immediately.
My problem is feeling cyclical and I can’t find a solution, any help?