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

http://h30499.www3.hp.com/t5/HP-Service-Manager-Service/Fetch-data-from-other-fields-save-it-and-show-it-in-another/td-p/6301925#.Uqlxx6Cb7IU

 

Thanks and Best Regards,

Sanjeev