Is it possible to create multiple links between one table and another? For example, can I link from Table A to Table B on both a Record Number and have a separate link by Company Name? I think the answer is no and that I should use a concatenated field for my primary field if I want to do that, but want to make sure.
I found some additional articles and forum threads that indicate that there is only a single link between tables and that AirTable uses a hidden UUID to create the relation. The primary field is another story and I’m still looking for best practices for those.
You can have as many different links as you would like between the same 2 tables, but your linked records always need to be manually chosen by you. So you would manually give human meaning to the different links. (In other words, Airtable doesn’t link based on field values, but you can manually create links.)