I'd like to be able to link records together in the same table, and view connections easily!
In my test base, I have a table that lists different talks. Some of them reference others, so I made a "Link To Another Table" field called "MENTIONED REFERENCES".
This allows for linking a record to any possible children records. But not vice versa.
I want to be able to see this link when opening a child record, to check what parents records it may have.
e.g. based on the above pic, if I opened Talk E, the new field should say that it is linked to
- Talk D
- Talk F
Ideally it'd be a field that lets you click on any Linked Records too, not just text.
I don't know if this is possible in Airtable. Is it possible to use a "LookUp" field? Or resort to Automation or scripting? Haven't had a successful result yet.
Here's a mock-up of what I'd like to have. (done in Microsoft Paint :P)
Any advice would be appreciated!