Hi,
I was trying to create a lookup that shows the list of employees from the department that is selected in the header. I have tried several things but I am not able to get the required results. A screenshot of the form is also attached if that could help you in understanding what I am trying to say. Can some body here guide me on how can I get to the solution? I am new to this so I don't know a lot about the hierarchies yet any detailed answer would be more beneficial to me. Thank you