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

Sumer Sharma
Tera Contributor

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

6 REPLIES 6

Sandeep Rajput
Tera Patron
Tera Patron

@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.

 

Screenshot 2024-08-11 at 6.01.42 PM.png

javascript:'u_country='+current.u_country;

 

Hope this helps. 

I tried but it is not working.

@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.