Can I create user level security with queries (1 Viewer)

[robert693]

Hello,
I am creating a database with employee records. The database will be used by department managers. I want the database to show only those employee records that are in the department that pertains to the manager that has signed into the database. When a different manager signs in he or she will then see only the employee records from their department. I would like to know if I could do this by using queries somehow?

Thank you for any help!

 

[DCrake]

Asuming that each employee has been assigned a department/manager in a field and managers login to the system. You can then apply filters to your queries to match up.

David

 

[robert693]

Thank you!