When there is a link field that links to records within the same table, is there a way to show the records that are linked FROM (as well as linked TO)? For example, see screenshot below, where there is a list of companies and a link field called "Key Customers" which references the list. I have dummied up the "Key Customer Of" field by creating a new link field - but I actually want this field to generate automatically based on the "Key Customers" field. In other words, instead of only showing the target records, can I also show the source records?
I think the answer is no because Airtable is a relational database and not a graph database. I know also that the documentation states that best practice would be to keep the customers in a separate table, but in this case that would require double-entry of many companies, which I very much want to avoid. If anyone has figured out a clever workaround I'd love to know!