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.