2. ASPRunnerPro General questions
  3. restricted possibility to edit records
This topic is locked

restricted possibility to edit records

 		5/24/2007 9:53:10 AM
ASPRunnerPro General questions
P
 Philip author

Hi
I'm working with 4.1 / 225.

I would like to prevent users to edit all records. My goal is that they see all records but can only edit those where field STATUS has the value OPEN. How can I achieve this?
Philip
J
 		Jane 5/25/2007

Philip,
you can do the following:

  1. select User can see all records: can edit their own records only option on the Advanced security settings dialog on the Security tab, select Status in the Main Table: OwnerID dropdown box and any field in the Users table: OwnerID dropdown box.
  2. add AfterSuccessfulLogin event on the Events tab. Here is a sample code:
    Session("OwnerID")="OPEN"