I’m creating an employee contact list and would like to be able to enter or select a Job and then have another cell populate the Department that corresponds to that Job.
For example, as I enter a new employee into the table, I’d like to be able to select “EM Vet Tech” in the Job row/cell and then have the next row/cell populate “Emergency” as the department. I’d also like it to later change the department when I change the job - so if I change job for a person from “EM Vet Tech” to “GP Vet Tech” I’d like the department to change from “Emergency” to “General Practice” automatically.
Is this possible? I’ve looked all morning and searched through the help but can’t quite find what I am looking for. I’ve also tried playing with linked tables, but I feel like the more I try to find a solution the more confused I get.