Using fields from another table as dropdown list in another table

Not sure if the original post was ever resolved - but in the setup you will need some kind of container / binder to contain your employee list and then you're dropdown for 'Crew' in this example would be a related field from that table. So using the original post as the example: 

Create a table for 'Crews'

Create a relationship between Crews to employees and the 'Crew' dropdown on an employee would be the related field to related a Crew to the employee. 

You can then summarize the list of employee names into the Crew using that relationship. In the 3rd table here - where you are again relating the Crew to it - you can then do a lookup of the employee names through the 'Related Crew' relationship to whatever your 3rd table is.