AnsweredAssumed Answered

Flat File Security

Question asked by ChristopherColes on Aug 16, 2010
Latest reply on Aug 24, 2010 by philmodjunk


Flat File Security


To all:

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!