How to limit a catalog item reference variable based on the value selected in another reference variable?

[gjz1]

I have two reference variables on a catalog item, one that references department and one that references division.  Departments and divisions are in two separate tables with department being the common field between them.  There are many divisions per department, I want to limit the values displayed in the division variable based on the selection in the department variable.  Any ideas how this can be done? 

[dvp · Accepted solution]

You can write a reference qualifier on division variable

Here is an example

javascript:'u_department='+current.variables.DEPARTMENT_VARIABLE_NAME

 u_department is the field name on division table

[Javier Arroyo]

it might also need a variable attribute of ref_qual_elements=[I depend on field name] with out the square brackets on the field dependent field to inform the field to refresh itself after a selection has been made

[gjz1]

Thank you DVP!  I thought I had tried your suggestion without success but it is the correct solution, I'm getting what I need.