Locking down a single record using a script

[Andy Robo]

Hey folks

So I've got this database, that has a layout on which there are fields, portals and related records... each record shown through this layout (an instance,if you like) is a Long Term Teaching plan... once teachers have filled out the plan (or the record/instance) I want them to be able to lock that record so they don't accidently trip a value list or other such thing.

(i'm aware that such a question has no doubt been posted before, but the search function on this site seems to be so date biased... so forgive me)

Basically I have a dynamic container that the user clicks - it activiates the lock script, and shows them a lovely little picture of a padlock. :-)

Want I want the script to do is...

1. Prevent the user from entering any field on that layout (but only for that record)

Any thoughts...

Andy

****************

Oh those Brumbies - did you see that... 5 tries in the first 20 minutes... oh my god!!!

[The Shadow]

Hi Andy,

You could use row-level privileges that made the record read-only for everyone if a special "lockField" wasn't empty. Trying to edit would give an immediate dialog, and you could still script an unlock just by clearing the lockField.