How to show only that records in reference field based on value in the other reference field?

[Sumer Sharma]

Hi All,

I have two reference fields named state and country. State field refers to state table and country field refers to country table. Whenever I select any of the country in country field then when i open state field i should see only that states based on country name. So how can i achieve this?

Thank you

[Sandeep Rajput]

@Sumer Sharma I am assuming that on the state table you have a column called u_country. If this assumption is correct, you can set the reference qualifier for the state field as follows.

javascript:'u_country='+current.u_country;

Hope this helps. 

[Sumer Sharma]

I tried but it is not working.

[Sandeep Rajput]

@Sumer Sharma Please share following details.

1. Name of your country field on state table

2. Name of country field on the form where you are filling the values.

[Mame Diarra]

@Sumer Sharma 
This might help : https://www.servicenow.com/community/developer-forum/reference-field-dependency-on-another-reference...