We have a second hand musical instrument store where items are sold on
consignment for a commission.
At the moment it is relatively easy to make an accidental keystroke and
unitentionally delete/modify fields.

Is there a simple script to safeguard accidental data entry on individual
records?
Ideally, I would like all fields to default to read only (aside from initial
creation) with "unlock" and "lock" buttons to allow editing (with a timeout
period, not unlike a mobile phone keyguard!)
Look forward to any suggestions!
Cheers,
Lewis

"Lewis" <swopshop (AT) tpg (DOT) com.au> schreef in bericht
news:4693440f$1 (AT) dnews (DOT) tpgi.com.au...
Create a dummy layout. This will hold all the fields needed, but you lock
the data entry for all the fields. So no-one can change anything. (Or if you
leave one field open, they can change just this field-contents). Then create
a button that fires a script. Perhaps asking for a passfrase, before
switching to the layout with the fully accessible fields.

A more versatile way would be to work with accounts and privileges, but
somehow I think this is not what you want.

Keep well, Ursus

Lewis wrote:
I use a scripted Locked number field, the user is asked to lock the
record (and effectively all related records) at authorization. Once
locked , either a password, or usually an admin level account is
required to unlock it.

The privilege set is configured for Records|Custom Privileges limited edit
IF( lock = 1; 0; 1)

e.g.
If(Episodes::Authorized = 1; 0; 1)

A script can reset the Authorized value


regards

Chris