Hi, I’m new to Airtable and haven’t been able to work out how to achieve the following:
I have a table set up called “Staff”, with a Multiple Select field for their department (Sales, Accounts, Design).
On another table “Project Number”, I would like to be able to assign a Sales staff to a project number. But I want to limit the list to only people who are part of the Sales team - Link to another record only gives me the full Staff list.
What would be the best way to achieve this?
I can achieve this by creating a third (junction?) table called “Sales staff”, but then there are two further issues:
- How to group sort the Staff list by department - the junction table means each Staff has a unique department ID
- How to make this system flexible if I add new departments (is there a way to automatically generate a new table if a department is added?)