In an Employee database which goes across several subsidiary companies I want each Company User to be able to see ONLY their company records but Group Users should see ALL records.
The data source for my form is a query:
Select EmployeeID, EmployeeCompanyID etc from EMPLOYEES where EmployeeCompanyID = [Forms]![Login].[UserCompanyID]
This works for each individual company but the vital bit I need help with is that Group Users (UserCompanyID = 0) must be presented with all records. Any help would be very welcome.
Chris
The data source for my form is a query:
Select EmployeeID, EmployeeCompanyID etc from EMPLOYEES where EmployeeCompanyID = [Forms]![Login].[UserCompanyID]
This works for each individual company but the vital bit I need help with is that Group Users (UserCompanyID = 0) must be presented with all records. Any help would be very welcome.
Chris