<div> I guess I'm still not getting it.........</div>
<div> In the "main"file, there are records associated with different clients.</div>
<div> In this particular instance, client number 4764 needs to have access to our </div>
<div> system via ssh to just VIEW their records, along with asociated notes that are</div>
<div> made on their records (these notes are contained in a separate file where</div>
<div> currently on our system there are browse windows created on screen 2 for us to</div>
<div> see the notes, etc.</div>
<div> </div>
<div> So, in playing around with @menu I have created a file that has 2 dummy fields</div>
<div> in it. So, if I now go to IUA and choose this "new file" it gives me the option to</div>
<div> search by name or account number (the 2 dummy fields I created)</div>
<div> However, when I do the @menu processing, it still shows ALL records in the</div>
<div> "main" file. I can't figure out how to do the browse lookup to the "main" file and</div>
<div> only show the records that belong to them. How would I accomplish this?</div>
<div> </div>
<div> My 2nd alternative I'm playing with is simply creating a "new" file and copying just</div>
<div> their records to it nightly and creating 2 screens for them to view notes, etc.</div>
<div> That is the "easy" way out, but not really how I want to do this in the event I have</div>
<div> future clients that want to also be able to see their data, I would like to have a</div>
<div> "solution" in place. I'm just stuck on the lookups and limiting them to seeing</div>
<div> just their data.</div>
<div> </div>
<div> They will have their own unique login, but I don't see how I would tie that in to</div>
<div> limiting the records they see unless I do what I just mentioned above and create</div>
<div> a new file for just their records?!!??! uggh.....lol</div>
<div> </div>
<div> Scott</div>
<div><br><br> </div>
<div class="gmail_quote">On Tue, Sep 1, 2009 at 9:24 AM, Joe Chasan <span dir="ltr"><<a href="mailto:joe@magnatechonline.com">joe@magnatechonline.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">you only need "lookup -" if you want to go to that record for update or<br>similar. "lookup -" moves the current record pointer to that record. if<br>
you are not going to update it it may not be necessary to use "-". a<br>regular browse lookup should do it.<br><br>i don't know what your criteria are for associating a record with a<br>particular login. maybe you need a reference file to cross-reference<br>
unix user login (@id) with customer # field or some other similar field<br>in that file.<br><br>once you figure that out you can decide if there is an index with which<br>you can restrict the selection or not - if not, when you define a lookup<br>
via <F5> you will see a prompt for "Processing Label" - this section of<br>your prc table gets executed for every record in the index before it gets<br>displayed. you create a section of your process table with this label, and<br>
its flow must end with an "end" statement - in it you can do lots of things,<br>but the main thing you are after in this case is some conditional logic<br>based on lookupfile(field) that an tell you whether or not to issue 'drop'<br>
command - which will prevent the display of that record in the lookup<br>browse screen. (e.g. if: lookupfile(5) ne "XYZ" then: drop)<br><font color="#888888"><br>-joe<br></font>
<div>
<div></div>
<div class="h5"><br>On Mon, Aug 31, 2009 at 03:30:26PM -0400, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>> Joe,<br>><br>> I have a general idea what you're saying....in fact I made a 'dummy' file<br>
> and added<br>> some @menu processing to browse records from the 'main' file, etc.<br>> I'm still not certain how I would limit the lookup to just their data?<br>> I'm also not certain how to write a lookup to another file when in @menu<br>
> processing......all I see is a 'dash' lookup in the examples I've seen in<br>> the manual<br>> how do I lookup to another file?<br>> Still trying to figure this out - ughh haha<br>><br>
> thanks again<br>><br>> Scott<br>><br>> On Mon, Aug 31, 2009 at 10:05 AM, Joe Chasan <<a href="mailto:jchasan@gmail.com">jchasan@gmail.com</a>> wrote:<br>><br>> > I am not near a computer with filepro right now, but the basic idea is<br>
> > this:<br>> > Call clerk on a file and have processing take over immediately, either with<br>> > @menu, or with -xe/@entsel combo. In that prc, prompt for input search<br>> > criteria - search key and search method if applicable. Take that info and<br>
> > use it in a browse lookup processing line. How you drop non-user-specific<br>> > records is on you then. If you are lucky, index may help, if not, use the<br>> > prc= part of lookup to use drop processing.<br>
> ><br>> > That's a simple browse display - you can add popup screens to that pretty<br>> > easily. since it is view only, you don't need to take it further than that.<br>> > Also, if it is view only - suppose it doesn't even matter what fp file you<br>
> > run this out of.<br>> ><br>> > -joe<br>> > Sent from my Verizon Wireless BlackBerry<br>> ><br>> > -----Original Message-----<br>> > From: "<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>" <<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>><br>
> ><br>> > Date: Mon, 31 Aug 2009 09:42:25<br>> > To: <<a href="mailto:joe@magnatechonline.com">joe@magnatechonline.com</a>>; <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>>;<br>
> > filePro Mailing List<<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>><br>> > Subject: Re: limiting browse based on login?<br>> ><br>> ><br>> > _______________________________________________<br>
> > Filepro-list mailing list<br>> > <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>> > <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
> ><br>> ><br></div></div>
<div>
<div></div>
<div class="h5">--<br>-Joe Chasan- Magnatech Business Systems, Inc.<br>joe - at - magnatechonline -dot- com Hicksville, NY - USA<br><a href="http://www.magnatechonline.com/" target="_blank">http://www.MagnatechOnline.com</a> Tel.(516) 931-4444/Fax.(516) 931-1264<br>
</div></div></blockquote></div><br>