Governance, Risk, and Compliance (GRC)

 View Only

 Dependent picklists controlled by related object fields

Daniel Valle Contreras's profile image
Daniel Valle Contreras posted Mon April 21, 2025 01:04 PM

Hi team,

I'm implementing a solution with OpenPages 9.0.0.4, basically I want to either hide or show options from an enumerated string field, based on the selection in a field of a related object.

For instance,

assume I have two objects X and Y where X is parent of Y.

Both objects shares an enumerated multi/value string field called Type with the values A, B, C, ..., Z.

If a set the Type from X to [A, B] and then,

I associate as parent of Y, I expect to see only [A, B] values available for Type in Y, instead I see the whole list from A to Z.

Is there a way I can achieve such kind of behavior?

Thanks in advance for the help.

Ian Sankey's profile image
Ian Sankey

It is not possible to restrict the list of values that appear for the same eunmval field in object Y.  You could use a calculation to SET the same values on Y that are set in X, but then the field is not editable on Y.  I assume you want the user to be able to pick all or a subset of the values selected on X?

Another option would be to use a CALCULATION to set the values on the same ENUMVAL on Y, but add a view rule to not display this field on Y.  Add a second separate ENUMVAL field for object Y which has the same values as the other ENUMVAL, and setup a dependent picklist to only show the same values that are selected on calculated field.   This way, you only see the subset from X to choose from.