A couple of things for public to be able to view the data in the join (as I understand it): - both forms must have Public permission (visible or hidden) - the entryid on both forms must have public or submitter (if the submitter is the person completing the survey) - if you want to restrict access on the join, then make sure either fieldid 4 or 2 matches the person completing the survey, then assign that as a permission group to the request id field - for your managers to view records in the join, make sure the join eid has the 'manager' permission group
Axton On 3/13/07, Reiser, John J <[EMAIL PROTECTED]> wrote:
Hello Listers, ARS 6.3 Patch 21 SQL Server 2000 Windows 2000 SP4 I am trying to restrict the records in a join form by only allowing the $USER$ to access records marked for the current account. Is this a variation of row-level locking? The Join is the "survey" form and the "reviewer" form. Many reviewers will see a particular survey when assigned to them. Will the access permissions on the Reviewer form affect the records seen in the join? I have created the join on the survey's Request ID to a SurveyRequestID field on the reviewer form. The reviewer form gets a new record for each survey/username to be reviewed. The Helpdesk Supervisor creates the record when she wants to send completed surveys to the Tier 2 person and/or their manager for review (atta-boys or tsk-tsk's). The primary audience are the managers. The receive a MidTier link and when they log in we want then to see Surveys for their people, that are newly received. But they may also want to see an old survey, so we will provide a state field for them to select previous records already "reviewed". I hope there is enough info here to make this understood. Thanks in advance. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
