Populating country based on region

[Community Alums]

Hi,

I want to populate country based on region.When I select Region - Europe its showing all countriesI am not able to achieve this.

Both region & country choices are stored in u_core_request table.

Thanks in advance

[Brad Bowman]

You only have the ^u_region criteria in the first if statement.  Is this working when the LE Group is Healthcare?  Does it work with Healthcare and Europe if those values are already selected when the record loads - like on the RITM after submitting the request?

[Community Alums]

Hi Brad,

I selected LE group - healthcare region- europe ,its showing all countries

[Brad Bowman]

I was asking about a distinction between selecting the values and the values already being populated when the form loads.  Add the Attribute

 ref_qual_elements=le_group;region;business_unit

to ensure the reference qualifier is updated when either of these three variables change.  You'll also need to verify that the values stored in each of these elements matches the values in the referenced table.

[Community Alums]

Can you specify where this attribute has to be added?

All these values are stored in u_core_request table