Is there a way to setup ‘is-a’ relationship among tables?
ex: We have a Person table with atttributes like email, name etc.
We want to setup Employee table that inherits all attributes of Person but has more attributes like salary etc.
Is it possible to setup “Employee is a (Inherits from) Person” relationship?
I am trying to utilize the lookup fields but when I go to use the result in a formula, the shortcoming is that it will create a circular reference. I have an accounts table and a parent accounts field which links to another record in the same table. Is there a way to break the circular reference in this scenario?
Circular references are a bit of a pain in Airtable. Airtable determines if something is a circular reference based on the field definitions, not how records are actually linked. You can create a gap in the circular logic, and then use an automation to bridge that gap by having the automation copy the lookup value into an editable field. However, note that you can end up using a lot of automation runs very quickly when implementing a system like this.