Hi,
I have been tasked with building our Sales/PM DB for our company. I am looking for help with user-level security for a Web DB (Access 2010). Our DB needs to be a Web DB since our Sales Reps could be working from any computer.
When a Sales Rep logs in, they should be able to see only their leads/opportunities/sales that they are associated with in each table (leadsTable, customersTbl, etc). Our Sales Managers, should be able to log in and see all his Sales Rep's data. I would like to stay away from creating hundreds of individual tables/forms for each Sales Rep/SalesManager. Each should be able to see their own records in the overall data sheets/tables.
I haven't had much experience with Access for this and I really appreciate any and all help!
Thanks,
Jenn