I’m working on my current doc setup for my base tables, and I was hoping to get some feedback on how I should setup the base tables for contacts and their relationships to each other and to organizations.
Setup 1 is what I currently have in my doc. I used a setup that I found in the gallery, so I don’t really understand how the formulas work. With this setup I have a table for Contacts, Organizations, Relationships (organization to organization), Affiliations (Contact to Organization), and Relationship & Affiliation Type DB. With this setup I have two columns in the Contact DB. One shows a Contact’s Relationships and another for their Affiliations. The Relationships column accounts for the Contacts listed in Primary Contact and Related Contact
Setup 2 is more what I’m looking to do. It has relationships and affiliations in one table and then I would have one column that pulls in all all relationships from the Affiliations & Relationships table. If I do it this way, the formula for naming the columns and showing their relationships is going to be more difficult to put together.
My goal is to streamline my Coda setup, starting with having as few base tables as necessary. Do you recommend combing these tables? If you do, how would I go about tackling the new formulas?
Thank you so much for your help!