Flat File Security
I'm looking to restrict access to sales reps in a quote database. I've created user accounts in the file and added a calculation that checks logged in name against sales rep name. It successfully shows only the sales rep's quotes but also shows all other records with <no access>.
I want the reps to see only their quotes and make a few revisions as needed. it would be nice to leave out the records with <no access> and the reps only be able to perform a find on their quotes.
Since this is a flat file there are no portals or relationships to help filter out what I'm trying to accomplish.
Thanks for any comments/suggestions!