Auto populate fields in a table, with fields from another table

So I have a table (Table 1) with employee names and some details.

And I want to create another table (Table 2) with one of the Fields being a name Field. And I want it to pull in the names from Table 1 into it’s name Field.

If a user gets deleted in Table 1, I’ll love for their row/Records to be deleted in Table 2 as well.

Is this possible?

Thanks a mil in advance for your response!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.