How to drill down on a reffence field

[John H1]

Senario:

We have two department fields (Department & Sub-Department)

Department is the Parent of Sub-department.

The goal is to select Department and have the ability to select the sub-departments based on the the Parent field being the parent value

[debendudas]

Hi @John H1 ,

You can use the below reference qualifier:

javascript:u_parent=current.u_department;

You can change the field names based on your table structure.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

[John H1]

I'm not getting the results I was expecting.

I have a Department field called IT
I have a second Department call Server Team (Parent = IT)

What I'm trying to do is have a reference field and then select the IT department
then in another reference field only have it show the Departments that have IT as a Parent (in this case Server team)

[debendudas]

Please follow the below steps: 

1. Goto the Dictionary entry of "Server Team" field

2. In "Use reference qualifier" field select "Advanced"

3. In the "Reference qual" field put the below code:

// Assumimg the name of the "IT" field is "it" and parent field of the "Server Team" table is "parent"
javascript:parent=current.it;

4. Goto the Dependent field section and in the "Dependent" field put the name of the IT field (Assuming "it")

5. Save the form.