In Airtable, my base contains tables named "People" and "Events". Multiple people can participate in multiple events and share specific types of relationships as a consequence. For instance, Person 1 (Charles) and Person 2 (Amy) can both participate in an Event named "Marriage of Charles and Amy", forming a specific type of relationship (spouses) as a consequence, so that Charles is "spouse of" Amy and Amy is "spouse of" Charles. Likewise, birth events create "parent of" and "child of" relationships, and so on. Using a junction table, what would be the best method to illustrate the types of relationships multiple people can share as a consequence of participating in specific events?
Question
People-Event Relationships
+12Tables:
People
Events: Links to People (Participants)
Relationships: Links to People (separate From and To fields), Events and RelationShip Types
Relationships Type (Specify From:To relation and To:From Relation in the same record) If person 1 and Person 2 are linked, Relationship Type is ‘Spouse of’ for both. If A child is born, From:To is ‘Parent of’ and to:from is ‘Offspring of’.
That should be it.
Ping me for consults if you need help with this or other issues: https://calendly.com/d/dvq-nvm-nhg
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.