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.
