Privileges by account name
I'm working on building an employment database that contains employees that work at a variety of locations whose managers need access to their employment record but I'm tyring to prevent them from accessing employment information for employees who do not work at their location.
I have two tables that are related by an ID number and here is what each table contains:
Employee information: Employee name and ID
Work History: Start and end dates, location, department, etc.
Right now (for testing only) the username is the location in question, so if an employee is working at Location A, the username is Location A.
Attached is an image of the security settings.
For each of the tables, the view is limited by the following calculation: "Work History::Location = Get(AccountName)"
This works only for one record, if I have more than one employee working at any given location only one shows up in the employee information table, the other records have the "No Access" across almost all of its fields (some are just blank). However, both reocrds do show up in the work history table, just not the employee information table.
How can I fix this?