Restricting Access

[Alberto]

I’m creating a database for budgeting purposes and because I don’t want
budgeting managers to see the salaries for other departments, I’d like to
restrict access.

I have essentially created 3 tables:

The first is a table that has the following fields:
Table #1: Departments
DepartmentID (key)
Department Name (Text)

Table #2: Salaries
EmployeeID (key)
EmployeeName (Text)
Salary (number)
DepartmentID (lookup from Table #1)
Budgeting Manager (yes/no)

Table #3: Expenses
ExpenseID (key)
DepartmentID (lookup from Table #1)
AnnualBudget (number)

I’d like to create forms where budgeting managers can add individuals to
their department (Table #2) or expenses to their department (Table #3).
However, I’d like to restrict the information that they have to their own
department. (i.e. the budgeting manager/s for Department #2 would only be
able to view the Salaries and Expenses associated with Department #2.)

I'd like to know how I can identify which person has opened the database so
that I can then cross-reference them to a specific department.

Thank you,
A