Locking a Record

[bpal]

I have a database that I use to manage Projects for clients. I am able to set Status to Pending or Open or Closed. I want to create a script that checks to see what the status is. If status = closed then the current record should lock itself and not be modifiable. I want to be able to change the status back to open if need be but if the status is closed then the rest of the field in the current record are not modifiable. Basically I have no clue how to lock the current record at all and then base it on these conditions. Any help would be great. Thanks.

[Ender]

There are a couple different approaches. First, you could use record-level access privileges to decide if the record can be edited. This would be setup in Define->Accounts & Privileges, under the privilege set's access privileges for Records (then for the desired table, select "Limited.." in the pull down at the bottom.) Use a calc, like: Status <> "Closed", which evaluates to true for the other values of Status.

Another approach is to use separate layouts for Data Entry and View, and have the navigation scripts control which layout is used based on the Status:

If [ Status = "Closed" and get(privilegesetname) <> "[Full Access]") ]

Go to Layout [ View Project ]

Else

Go to Layout [ Edit Project ]

End If