I’ve become pretty proficient in Airtable over the last year and have used it for countless purposes. However, this one is stumping me a bit.
Within the same table, I want to link record A to record B, and have that link show up in two separate columns indicating the relationship. Example…
I’m creating a base to track cattle for a farming business. One table will have “inventory” to track all of the cattle; previously and currently held. Some cattle will produce offspring and I would like to track this in the same table by using linked records. I would like one column to indicate the parents and a separate column to indicate children/offspring. Here is a basic example:
Obviously, the table would track much more information than this, but the link is where I’m having trouble. By adding “parent” to one column, I want the linked record to show a cross-link under the offspring to show the relationship.
I’ve been able to do this by creating a 2nd table that links “family ties” and shows the relationship that way, but I’d prefer to use just one table.
I also tried using automation, which works great if there is just one link. The second I add a second child or a 2nd parent, Airtable can’t determine which record(s) to update.