How to drill down on a reffence field

John H1
Tera Guru

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