Allow record creation but not update

[rew62]

On the face of it, a simple request, but I'm struggling to implement this.

I need to allow users to add records to a table, but once the record is commited I need to restrict the update of specific fields. An admin user should be able to update these fields.

Any suggestions welcome.

[Steven H. Blackwell]

First, welcome to FM Forums.

This is part of what is called Record Level Access. In the Manage Accounts & Privileges section for the user's Privilege Set, set edit records to 0. Allow creation of records. When user creates new record it can be edited until it is committed. Thereafter, it cannot be.

Steven

[rew62]

Many thanks, that did the trick.

[Steven H. Blackwell]

Excellent. Glad it is now working for you.

Steven