Multiple Tables with Same Primary

Topic Labels: Base design
185 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


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!

0 Replies 0