Hello Guys,

This could be under the security thread, but I am mostly after design ideas, so I placed it here. Any ideas and suggestions are appreciated.
My goal is to limit query results based on the user running the query. This is easy enough at first glance, but I have another layer to it that is causing me issues. I have a table(tblPurchaseOrders) where all of my companies orders are inputted via a form. The sales persons is associated with every PO listed. Every Salesperson has an assistant, and some have multiple assistants. The salesperson should see all of their own orders, but the assistants should only see the orders that they are associated with and not the other assistants under the sales person. I have thought of a few ways to do it, but they seem a bit over the top. If anyone has a simple design for this, I would appreciate it. I don't need any code, just design ideas.

Thanks


I didn't find the right solution from the internet.
References:
- http://www.accessforums.net/showthread.php?t=66930
- Cleaning Solution Video Examples.

http://www.sql.ru/forum/1267697/design-to-limit-database-viewing-rights