I am stuck!
I am attempting to set up a scenario that will allow me to restrict viewing of certain records depending on which user is accessing the system. I am not using the built in MS Access workgroups function.
Instead i am having a user table that requires a user to have a username that is the same as their windows system login. I am then filtering the query by fOSUserName.
I think this approach works fine when allowing one person to view records directly related to them. However I need to allow people to view records that might not directly be them.
For instance. If a new secretary is hired. And we want her to view only those records associated with the managers that she supports.
How can I accomodate this. I would like to when creating the the new user specify which records they can see and which they cant.
To give the project some more context, it is a task tracking database. So a task is created and assigned to one or more people. Those people need to be able to see the records they have been assigned. Plus their secretaries need to be able to see it. A secretary is never directly assiged a task.
Any suggetsions would be a life saver!