Set up a dropdown that follow hierarchy
I have a hierarchy that has Cost Center → Jobs. A Center can have several jobs.
I have a dashboard where a user can add a new FTE for a job. When they select a center, it should show only the jobs that come from there. Right now, I have a form that they can fill out and when they select a center, it shows all jobs available across the entire company.
Do you know any way to restrict the jobs in a form? In the example, Housekeeping is the Center. But it is showing jobs from our retaurant called Monkey Business. This should all be greyed out.
Any help will be greatly appreciated. Thanks!