Welcome to the community, @Sydnie_Russian!
Lucky for you, there is a very simple way to convert all of those individual fields into a single multi-select field.
All you need to do is create one formula field that combines all of those field values together with commas in between each field value.
So your formula field would look something like this:
{HR} & "," & {Management} & "," & {Production} & "," & {Ask A Painter} & "," & {Sales/ Marketing}
You would just keep building onto that formula with all of your field names. And separate all of them with commas.
The result of your formula might display a bunch of commas in a row for any of your fields that are empty, but that’s okay.
When you’re done building your formula so that it includes all of your fields, then you can just convert your field from a formula field to a multi-select field. Airtable will automatically take each comma separated value and make it a multi-select option — and it will choose the right selections for each record.
You can do a similar conversion for whichever text field you want to link to the master table. You can only link to another table based on the other table’s primary field (the first column). So take a text field in your current table that matches the values in the primary field of the other table — and then convert the field from a text field to a “link to another record” field.
