Creating Two Dependent Picklists – Second Field Based on First Field Selection

Hi everyone,

I'm working on a use case where I need to create two dependent picklists in Oracle. The idea is that the second picklist should dynamically display values based on the user’s selection in the first picklist.

The first picklist is based on a value set that lists the Job Families.

What I would like to achieve is that the second picklist shows only the Jobs that belong to the Job Family selected in the first picklist.

Has anyone implemented something similar or can recommend the best way to do this? Ideally, I’d like to pass the selected Job Family as a parameter into the value set used in the second field.