Trusted Contributor
Filter data in a dropdown field, related to the data from another field

Hi Experts,


I have two fields "Division" and "Assignment Group" in a custom made form.

Division is a text field and Assignment group is a drop down menu with value list $G.assignment.groups

In assignment file the Assignment group(name) is related to the division.
For example lets say division 1 has group A, B, C

and division 2 has group D, E, F

and so on.


Now when i click on the Assignment group dropdown its showing all the groups irrespective of the division.

How do I add a filter so that the assignment dropdown menu show the groups only related to the division?


Any help will be appreciated.


Also please have a look on the link mentioned below


Thanks and Best Regards,