Dwayne, I would advise you to solve this at the source. If you do not want them to see other records than those that are assigned to them, just make sure they only have rights to see these records by implementing Row Level Access - either by using the Assignee field or by using the special 112 field. This way you're sure that they can only search and see their own records. In my opinion this would be a much better solution than using active links.
-- Met vriendelijke groet / Kind regards Michiel Beijen ______________________________________________________ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl On Nov 30, 2007 8:27 PM, Dwayne Martin <[EMAIL PROTECTED]> wrote: > Hello Everyone, > > We have a main Form A, and a subfile Form B. The assignee in Form B can > click a button, which will call an Active Link, which will open the parent > Form A. If the user has only "Public" permissions we do NOT want herm > (her/him) to launch a general query and see other Form A records. BUT we > want users who DO have write permissions to Form A to be able to launch a > general query and see other Form A records. > > If I disable the "New Searches" button, our users with write permissions > won't be able to launch queries. > > I tried using an active link to check the user's permissions, and send an > error message if heesh doesn't have any. The trouble is, when you do an > "Open Window" action to display a selection of records, the link first does a > search, so whether the link fires on "Window Open", "Search", or "Window > Loaded" it fires before displaying the records and the user doesn't even get > to see the records you DO want herm to see. > > Any suggestions? > > (ARS 7.1, RH Linux server, Oracle 10.2 db) > > Dwayne Martin > James Madison University > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
