I just got started with Airtable and have imported a couple of records that make up a many-to-many relationship. The base structure is fairly simple:
User (user_id = 5) <–> join table (join_id = 124 with user_id = 5 & group_id = 33) <–> Groups (group_id = 33)
So users & groups each carry a primary ID / key and are connected via the foreign keys / IDs in the join table.
I linked the records together fine and can add lookup fields like “user name” in the group table but those are merely text fields and not clickable – instead the ID field that ties the records together is the clickable one.
How can I choose which field is used for switching between tables / triggering the popups and pulling in the data from other records?
The client I am building this for won’t accept an ID field to have to click upon and I want a clean and logical interface…
Or do I have to get rid of the imported IDs since Airtable uses its own unique IDs and tie the records together based on the desired clickable field (f.ex. user name)? If so then how do I do that and how does Airtable prevent errors with duplicate names or similar pitfalls?
Thanks for your input!
P.S.: I did study the docs already but maybe I missed a crucial part?