I have an Event Table and Form.
I also have an employee Excel Spreadsheet with employees.
I linked the employees to a chlid table(Assigned Emplyees) of the Event Table(first name and Last name).

I want to be able to enter one event and then add from one to several people to work the event.

What is the cleanest way to do this?

Also, once a person is selected to work the event, If I choose to add others, the ones who have been selected don't continue appear in the selection list.

Thank you for the guidance.