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
+28Hey
What is it that you will be using this junction table for?
I don’t think it really matters (again, might depend on your use case), but you might actually want to have TWO records per relationship.
E.g.
Mike<Parent>Tom
Tom<Son>Mike
Either way (one or two records) you will want to have two fields linked to the contacts table, and one table linked to a Relationships table (or single select).
Feel free to grab a slot if you’d like to go through this on a quick call!
Mike, Consultant @ Automatic Nation
YouTube Channel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.