Here is an idea.
Create a table of ALL the Crew members (you actually have this already, but maybe flag the Active ones)
Lookup the Multi-Select field own to the Crew Assignments.
Make a formula checkbox field called [Valid for Schedule?] which will be true if the Assigned Crew Member is in fact part of the multi select field choices.
Then create an Automation which will trigger whenever a Scheduled is added or edited and the multi select crew field changes.
Step 1 of the Automation will be to purge all the children Crew assignments of the Trigger Schedule record . That way you are always starting from a clean slate.
Step 2. Copy ALL the possible Active Crew members off the master list of Staff into Crew Assignments for the trigger Schedule.
Step 3. Delete all the crew assignments for the trigger Schedule which are not valid for the chosen multi select lookup field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
