I have a table filled with people. Some of these people are related.
(this is not my actual data, but I thought it easier to explain than the slightly over-complicated reality).
I want to record those relationships within that one table.
1) So if Matt is Jim's son, I'd want Jim's record to state that Matt is his son, and Matt's record to say that Jim is his father.
2) Then, if I later add Lisa as Matt's sister, I'd want Jim's record to automatically show that Lisa is his daughter.Does anyone have any ideas about the best way to set this up?
I can get 1. working by setting up a hidden second table and running two relationships to it from my main table, and then setting up an automation so that when I add one record in this hidden table, it creates another record with the inverse information. I'm guessing this isn't the best way?