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

[Satishkumar B]

@John H1Department & Sub-Department dependency can be configured through the "sys_choice.list" table:

……………………………………………………………………………………………………

Please Mark it helpful 👍and Accept Solution✔️!! If this helps you!!

[AndersBGS]

Hi @John H1 ,

Just utilize a reference qualifier where you depend sub department based on department selection.

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

Best regards

Anders 

[debendudas]

Hi @John H1 , 
If the Department and Sub-Department is a reference field, then configure the reference qualifier.

But if these fields are choice fields, then use the dependent value for the choice.

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

[John H1]

Thanks, what would that reference qualifier look like.  I'm still learning this stuff.