MeaganMcOlin
5 months agoQrew Trainee
Tying Fields Together
I have an app with 3 connected tables:
When adding a "Permission" to an "Access Group" I can choose/write in a new Department:
I want the Department to be tied to the Employee. When I add that employee's name to another Access Group, I want it to auto-populate the "department" field. Also, when I go to the "Employee" table, I would be able to sort by department.
Does anyone know how I could do this?
Thanks!