Need to populate location field based on the country selection

[rog]

Hi all,

I have a requirement where in we need to populate the location (reference to cmn_location) value based on the selection of country (reference to core_country). If for example countries Japan and China are selected then on the locations that are active under these countries should be available for selection in location field.

I got to know that we need to achieve this through script include and advance reference qualifier since the location field is a reference field.

Could you please help me with the script, Im fairly new to scripting and would be a great learning for me.

Thanks in advance.

[rog]

This is a record producer on the HR scope and all the fields are also on the HR scope.

[Prins Kumar Gup]

And do one thing, create another script include as same and give the accessible from is all scope. 

[rog]

even after selecting country as India, it is showing locations of other countries.

[Prins Kumar Gup]

okay got it, please change the country field name in your script include line number  7. what is your country field name

[Prins Kumar Gup]

I think it should be  :- u_select_the_countries