Hello! 

Very new here, so bare with me.

I have a table of employees. One of the fields in the table is which states the employee is licensed in.

I then have tables for each state. In those tables, I would like the names of employees licensed in that state. I will then use tables to keep track of state-specific details, like license number in that state. 

I'm wondering how I can make it so that if I add an employee record, and then add a state to the state field, that employee also gets added to that state's table.

Thanks so much!