Populate field w/list of managers
Employee management DB.
Each employee record has a field for his/her position.
Each employee record has a field for his/her manager.
Some employees will have the position of manager.
All employees will have a manager.
How can I populate the Manager field with a list of employees who are managers and ONLY the employees who's postion is Manager?
I know I need as much direction as you can provide.