Hi,
I need your help for the following situation
I have 2 tables :
- Headcount : Employee ID, Position Name , Geography ID ( depending on the position can be Branch , District , Region)
- Hierarchy – hierarchy between the Branch / District / Zone
Mention - Geography ID ( depending on the position can be Branch , District , Region)
My question is : How do I connect this 2 tables taking into account that in the end I want to have a list / checkbox with Branch / District / Region and depending on my selection will display the associate list of employee.
Thank you,
Andreea