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.

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 ).

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.

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

Status = "Posted", 0, 1

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.

Please, put it up in our Standard Files forum.

Considered writing an article on locking records?

An e-mail should be in your box.

Thanks

-j