Hello,

Is there a way to lock records?

Something like a calculation: if (lock ,lock record,"")

Keep me posted

Greetings Jukkie

Version: v6.x

Platform: Windows XP

Hello Jukkie,

You are using FileMaker 6, which supports record level access (RLA) control via the Access Privileges/Passwords dialog (RLA was introduced in v5.5).

That being the case, what I suggest you do is:

1. Create a number field called 'Lock' and attach a checkbox value list with the value 1.

2. Set up limited edit and delete privileges via RLA, with the formula not lock = 1

Then, by checking the checkbox of the 'Lock' field, you will be able to prevent further editing of the record.

Hello Ray,

Thanks for your reply. It works perfectly.

Is there also a option for one or a couple of fields? If so I see a lot opertunities.

Greetings Jukkie

You can lock one or more layouts by this method, but using RLA to lock some fields and not others on a layout is problematic because RLA is not updated as you move between fields.

You can, however, use a similar approach to lock individual fields by specifying the formula not Lock = 1 as a validation calculation for particular fields (with the strict option enabled and a custom message if validation fails which says 'This field is not modifiable').

It's not quite as user-friendly because users will not see the message until they try to leave the field (whereas RLA posts an error with the first keystroke) but it will nevertheless be very effective.

Sorry,

Can you explane this alittle more if I am using FM7?

I want to do something just like this...but do not where to find RLA can you help?

Joseph

Hello Jukkie,

You are using FileMaker 6, which supports record level access (RLA) control via the Access Privileges/Passwords dialog (RLA was introduced in v5.5).

In v7, it is under the 'Accounts & Privileges' sub-menu of the 'Define' menu item on the File Menu.

To access RLA settings, go into the Privilege Sets pane of the Define Accounts and Privileges dialog and open a privilege set for editing, then from the drop down menu for 'Records' at the top right, select 'Custom Privileges'. You'll then be presented with the dialog within which record level access settings can be specified. Note that in v7 the dialog is called 'Custom Record Privileges'.