I’m having a heck of a time trying to create a sort of CRM in Airtable. I have a table for contacts (faculty names) and another table for courses. I’m trying to link the courses table to the faculty table by using the faculty ids from our directory. The goal of this would be for the records to match up so that I can see “so and so is teaching this course and here is their faculty info”.
When I “link to a record” and pair the primary key from the faculty table – it automatically creates them new instead of linking to existing. What the heck am I doing wrong here? No matter what order I try and do it in – it always seems to result in that.