I have set up the following terms hierarchy in the Term Store:
- My Terms
- Departments
- Accounting
- Project Accounting
- Procurement
- Human Resources
- Payroll
- Recruiting
- Accounting
- Departments
I have then created two columns:
- Department - managed metadata column bound to Departments term set
- Category - managed metadata column also bound to Departments term set
What I would like to do is when I create a new list item, I want to choose a Department and have only "Accounting" and "Human Resources" as available options; and then have the choices in "Category" matching the children of selected department.
Is that possible without coding?