I’m trying to figure out how to model a hierarchy. The Airtable Beginner’s Guide to Many-to-Many Relationships briefly discusses an example that matches my use case pretty well:
“For example, let’s say that you have a company directory with the names of all of employees: you want to model the relationships between managers and their subordinates, given that each manager manages many employees and each employee has only one manager. To do this, you could create self-linking linked record fields for each individual’s manager and subordinates.”
What I’m trying to figure out: Is there a way to avoid having to specify both Subordinates AND Manager? Both fields are critical to have, but one can be derived from the other. To be more specific: I would like to only specify Subordinates and have the Manager automatically computed. Is this possible in Airtable?