Windows 10 
Office 365
I am building an IT database that houses devices that we inventory and those devices are all assigned to employees. Employees have managers, and may have more than one manager. Each manager should be able to see only their employees. I currently have a login form that utilizes the employee table for the username combobox.
Because an employee can have multiple managers, i created a junction table to create the many to many relationship. The login form references the employees table, but the queries/forms for the managers reference the junction table... I can pull information from the employee table into the junction query, but once i try to add criteria to the query, based on the username combobox from the login form, that is where i'm getting stuck and things seem disconnected.
I tried basin my login combo box on the junction query, but that also did not work, kept getting errors.
How can i tie in the user that is logged in to the query/form for the manager, so they see only their employees? I keep having a hard time due to the disconnect between my employee table and my manager table.
Reply With Quote
