Restrict Drop Down Choices Based on Assignment Group

[kevinthury]

We have a goal of restricting a new drop-down list on the Incident form based on what is selected for the Assignment group. 

In my Personal Instance, I created a field of ‘Assignment Group Detail’ (type=string) with a number of choices.  I modeled the functionality after the Category/Subcategory list in that I added set the ‘Dependent on field’ to Assignment Group and the Choice dependent value to a Group name.

This failed to offer any values.  I tried to change the Dependent value to the sys_id of the group, and that failed as well.

The only way I was able to get this to work is by creating an OnChange Client Script that would copy the value of the Assignment Group field to another string field.  I then changed the Dependency to that new field and the drop down was properly constrained by the Assignment group choice.

While this is producing the desired results, I am questioning the efficiency.  Is there a way I can get the same results by having the Dependent field be Assignment Group and bypass the need to copy the value?

[kevinthury]

Marking Chuck's answer as correct as this method allowed us the most flexibility in using across multiple forms apart from incident.

Steps Taken to Resolve:

1.  Created a new Table to house the data

2.  Created a column on the TASK table referencing the newly created table and added dependent field value (in my case...assignment_group)

3.  Added the newly created column to the Incident form and configured.  (New column can also be added to other forms as needed.)

[Max C1]

I did a client script to display different category options based on assignment group and another to load the correct subcategory dependents. This wouldn't work for you?