"Locking" a record

[nightdesigns]

Is there a way to "lock" (i.e. prevent any changes) to a particular record from specific users when a certain field has a specific value? I'm trying to keep users from tweaking a "posted" record, thanks.

[Kurt Knippel]

Filemaker 5.5 implemented calculation based record locking. You can seperately lock out browsing, editing and deleting. The calculation must evaluate to a boolean value (1 or 0).

At its simplest the calc for editing could be If ( Field = "Posted", 0, 1 ).

[nightdesigns]

Filemaker 5.5 implemented calculation based record locking. You can seperately lock out browsing, editing and deleting. The calculation must evaluate to a boolean value (1 or 0).

At its simplest the calc for editing could be If ( Field = "Posted", 0, 1 ).

You happen to know how to set up that calc?

Thanks.

[Kurt Knippel]

Assuming the name of you field is "Status", the calc is:

Status = "Posted", 0, 1

[DykstrL]

I created a file that demonstrates how to "lock" records - and it works in 4.0 or 5.0. If you want to, email me and I will send it to you.

[Kurt Knippel]

Please, put it up in our Standard Files forum.

Considered writing an article on locking records?

[nightdesigns]

An e-mail should be in your box.

Thanks

-j