Are you familiar with: "Editing record access privileges" in FileMaker Help and this particular sub section: "Entering a formula for limiting access on a record-by-record basis"?
The details will depend on what data you have to work with in your tables and how your tables are linked in relationships, but the "lock expression" that controls access to specific records can be a different expression for different privilege sets. Employees would use one privilege set where the value in a field is check to determine if it is one of "their records"--perhaps by a field that auto-enters an Account Name when the record is created.
Managers would have different privilege set with a different lock expression that determines whether that same field value makes it a record "owned" by an employee from the manager's department or the lock expression might check a "department" field to make that determination.
Executive Managers would then have a privilege set that does not have a lock expression as they are granted access to all records.
Yes in fact I am using Get (AccountName)= zCreatedAccountName for View, Create & Delete for Employee records now...
I knew the answer was in there, I am not correctly thinking though how to relate each Manager, their location, their department and Employees. Yet, it’s all there in the tables. Thanks for confirming I am headed in the right direction...