This isn’t yet possible in Airtable because we can currently only link tables to tables (not fields to fields), but it would be really awesome if we could link a collaborator field (that IS NOT the primary field) in a “Projects” table to a matching employee name (which IS the primary field) in an “Employees” table.
That way, we could get all the extra features & benefits of a collaborator field, while simultaneously getting all the features & benefits of a linked field. 🙂
The workaround for now is pretty simple: We just have an extra field inside the Projects table which is the link to the employee table. (Only problem is that we now have 2 fields in Projects which have the exact same information in them.)