Have users access only specific records

[kcolbert01]

I am setting up a datebase where users will sign in. I have some idea of user level security however when managers sign in I would like them to be able to access only the employees that are in their department.

This database is mainly used for entering data in forms but the problem is that when a manager enters the employees ID # the employee's information is auto populated in the fields of the form (including sensitive info like salary and SSN) I would like to set something up that could prevent them from entering the company's VP employee # and seeing thier info. Up until now I have been deleting mgr and vp info - but that's only a temp solution.

If anyone can point me to a link where this action has been decribed in detail or if anyone can tell me how to do this - I would appreciate it.

Thanks,
Kim

 

[Jack Cowley]

You need to add a field to the table so you can distinquish VP's, etc., from records that are OK to view. Based on who is logged in to the database you can filter the data so that only designated people can see the restricted records.

hth,
Jack