limiting browse based on login?

[Joe Chasan]

On Fri, Aug 28, 2009 at 11:17:06AM -0400, scooter6 at gmail.com wrote:
> I have a client requirement in getting some new business.
> 
> I have a master file all setup with 1/2 million records.  Just about
> everything that happens on this system is based on what is in this file.
> Each record has a unique number  1234-0001    with  1234 being the client
> number, then their records for that client are 1234-0001, 1234-0002, etc,
> etc.
> 
> This new client wants to be able to browse their records by logging into our
> system, etc.
> What I'm trying to do is perhaps create a few different "browse only"
> screens off this master file, but I need to limit them to only seeing their
> own records when they log in using the login ID I give them.  This is on a
> SCO OpenServer system, if that even matters.
> 
> So, basically I want to create a "custom" browse so when this client logs
> in, it will give them a simply menu of "browse your records" and I want them
> only to be able to see their records, not everyone elses.  Hope this makes
> sense.

without knowing more about your application or what you mean by "browse
screens", it is difficult to answer.

2 ideas come to mind immediately.
a) copy user-specific records (only) to a file or qualifier specific to 
that user and give them access only to that
b) per another recent thread on this list - don't give them access to
filePro's I/U/A menu at all, but instead have your own prompts and display
via lookup browse that you define in processing (where you can limit
records based on login) instead of fp's browse built into clerk.

-joe
 
--
-Joe Chasan-                           Magnatech Business Systems, Inc.
joe - at - magnatechonline -dot- com   Hicksville, NY - USA
http://www.MagnatechOnline.com         Tel.(516) 931-4444/Fax.(516) 931-1264