Force Selection of Child Enumeration values
Given an enumeration list that has children for each parent, is there a way to force the End User to select only the child entries and not the parent. Say we have an enumeration list of States --> Cities. We want to force the user the pick the city, not state. Consider City can be repeated under multiple States, but the State/City combo would be unique.
Our problem is actually 3 levels deep, so think Country --> State --> City. User has to pick the city and the automation behind the scenes will actually consume all 3 levels.
My first idea was this 3 level enumeration, but also was pondering 3 custom CIs with Relationships. Then having 3 Query Pickers dependent on the previous selection and populating the child from the selected parent. That one hurts my brain and I'm not even 100% that it's possible.
Any feedback is greatly appreciated!