Limit viewing privilages

[ChronicFear]

Hi,

I have a form that is linked to a table and displays employee information (address, phone number, etc). It shows this information for both work and personal. I would like to set viewing privilages so that managers can view all the information for everyone, all employees can view everyone's work information, and any given employee can view their own work and personal information, but not the personal info of anyone else.

I've been able to get my form to do each of those things seperately, but not all at the same time. So for example, I can write an If statement to check the user's ID and if it matches a manager in the table, then it shows everything, else it only shows work info. I've also tried filtering by user ID so that the person can view their own record, but then they cant see anyone else's.

I would appreciate suggestions on how I might go about accomplishing this.

Thanks,
CF

 

[heedaf]

Have you tried setting permission via login ID? Can you give more detail on what is not working?
DeWayne

 

[ChronicFear]

I've uploaded a quickly stripped down version of what I'm trying to do.

So this is the form. I'd like to be able to do the following if I'm a:

Managers:
See and view everything in the form. All fields, populated with all data about every employee.

Employees:
Able to view the top half (work information) about myself and any of my fellow employees. I will NOT be able to view personal information about anyone but myself, but I WILL be able to edit and view my own personal information.


Hopefully this helps clarify.

-CF

 

[ChronicFear]

***Bump!***