I was wondering if anyone can help me with regards to creating Option list. Whats happening in my organization is there are set of metadata values
Department is interdependent on Location. Operation is dependent on Department and Process is interdependent on Operation. Whats happening in my case is per say there is a department value ABC in a location called 1 and there is another department value called ABC in location 2. The operation values falling under both these departments are showing up in checkin page.
I wanted to see if anyone there can help me break this relationship.
Essentially, if I select ABC belonging to Location 1, only values for that location and department should show up and not the values for Location 2.