How to show only that records in reference field based on value in the other reference field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2024 04:59 AM
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
- Labels:
-
Human Resources Service Delivery

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2024 05:33 AM
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2024 09:44 AM
I tried but it is not working.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2024 06:56 PM
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-11-2024 05:36 AM