Hi there, new to Airtable but familiar with relational databases. We want to import a CSV on a regular basis and then from the mapped data, have it fill data that is already in a lookup table.
The specific problem we want to solve is this:
We have a CSV file with a list of courses and instructors associated with the course. If the course in the CSV is SOWK 600 we want to import into our Fall 2021 table and have it link to the Courses table and the faculty table.
Can that be done? The relational database side of me says it can but i cannot find the appropriate terminology for Airtable.