limiting browse based on login?

[Nancy Palmquist]

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.
>  
> Thanks in advance
>  
> Scott Ullmann
> PDM, Inc.
>  
> ------------------------------------------------------------------------
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>   
Scott,

I did just this for salesmen years ago.

Logic was simple.
Make a screen that reads "  Press "M" to browse your data "  Or some 
@keyM that will put them to the right data.

In automatic processing, add a few lines of code that if the customer 
number does not match the current record do a screen "NODATA" and 
display the aforementioned screen.

On a screen they are allowed to see, do a screen "A" to put them on the 
right screen.

This will display the screen based on the customer.

Now you have to disable browse, @menu, forms, etc.  Replace with 
controlled processing.

If I could remember which project included this logic, I would look for 
it.  I have done too many over the years.

It also works to put them in an entirely different file and offer them 
browses to review the data, and then use V (popup on a browse) to 
display any record they want to see)  Much more controlled.

Nancy

-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com