How to limit reference field variable based on the value of another reference field variable on a catalog item

gjz1
Giga Expert

I have a catalog item with two reference variables on it and I need to make the available values on the second variable based on the value selected on the first variable. I wrote a script include for the reference qualifier but I'm having trouble passing the value of the 1st reference variable to the 2nd's reference qualifier.  Can anyone help me with the proper syntax?

Tables:

sys_user - has the user's department as a field

u_divisions - has a list of divisions that belong to a particular department.

1st reference qualifier: requested_for based on the sys_user table

2nd reference qualifier: I want all divisions in the same department as the requested_for's department.

 

find_real_file.png

 

1 ACCEPTED SOLUTION

Mike Allen
Mega Sage

Should be current.variables.requested_for

View solution in original post

2 REPLIES 2

Mike Allen
Mega Sage

Should be current.variables.requested_for

Ah!  I feel foolish now!  Thanks, that was the correct answer.