Lisa Westerfield wrote offline:
"Another option may be to create a "public" view of form B and remove the
search button from that view. In a past life, we controlled some similar
access with this approach." (quoted with her permission.)
So I made a "Public" view of Form A.
Then I made an Active Link that sets "Int dsp" field = "LENGTH($GROUPS$)"
So now when someone clicks the button, the first link gets the length of the
GROUPS keyword. If it is somebody from the general public it will be 0.
The second link runs if "'Int dsp' > 0" and opens the "Default Admin View" of
Form A, which allows new searches.
The third link runs if "'Int dsp' = 0" and opens the "Public" view where the
"New Search" button is disabled.
(I have to do some added Run If qualifications, otherwise I could open the
"Public" view as an Else Action.)
Thanks Lisa, and everyone else who responded.
Dwayne Martin
James Madison University
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
--- Begin Message ---
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"
--- End Message ---
