Hi Community Experts,
I have a requirement where I need to fetch the data of Department Hierarchy.
I am unable to find the data of these departments mentioned in the parent-child relationship in SQL.
The requirement is to display all the departments in a dropdown and when a department is selected, its parent must be auto populated in a text field as per the configured hierarchy.
As per the above image, if I select "IT" on any position details form in department field, "Finance" must be populated in another text field.
I have no problem auto-populating the fields, I am just stuck with the table relations of this parent-child hierarchy of departments.
Looking forward to usual helpful responses.
Best Regards
