lock a record

[Colin_Taylor]

just a simple one from a beginner but how can i lock and when neeeded unlock a record so others cannot change it

thanks col

[Steven H. Blackwell]

Create a field in the record, auto enter 1. Then in the Privileges Set definition, simply set the edit privileges to be this field.

When the field is changed from 1 to 0--by whatever process you use--the record will be locked for all users of that Privilege Set.

HTH

Steven

[polarpro]

Steven,

Thank you; this is a great feature.

And it looks like it works fine on hiding records completely, too. I created a field called paperbin, and when a user "deletes" a record the value of paperbin is being set to 1. The calculation says records with paperbin = 1 cannot be viewed.

Any pitfalls I should be aware of?

: Mike

[polarpro]

Using these settings in the RLA works great when hiding a record "completely" from users. I have a second request right away, if you don't mind.

I have different layouts: On the "Reference Mode" layouts the normal users can search and view records; and on the "Editorial Mode" layouts several editors can search, view and edit the records they are responsible for. When an editor works in "Editorial Mode" I do not want him to be able to see (and edit) records he is not responsible for. Currently, a search script takes care of this ("Constrain Found Set..."), But I'd prefer to do this in the Privilege Set right away. Is there a smooth way to do this?

Thank you,

Mike

[Steven H. Blackwell]

While using RLA,if you do a search for a category of records, FileMaker Pro will automatically [color:red]exclude from the resulting found set any records a user is not supposed to be able to access.

Steven

[polarpro]

Hey,

Thank you very much for your help.

Mike

[Steven H. Blackwell]

Very welcome.

Steven