3 Replies Latest reply on Mar 29, 2017 1:52 PM by philmodjunk

    Locking a Record


      In my solution there is a number field (BdFt) in each record and I'd like to lock each record when BdFt value drop to zero.


      My question is, is there a way to lock the entire record or am I stuck with changing the behavior of each record field?

        • 1. Re: Locking a Record

          If your users are logging in with a privilege set that is not [Full Access], you can set up a record level access expression that does not allow editing unless that field has a value greater than zero.


          Open up the privilege set definition in Manage | Security.

          Select "Custom Privileges" in the Records Drop down

          Select the table where these records are defined by clicking the table name

          Select "Limited..." in the Edit drop down

          Enter an expression that evaluates as True when you want users with this privilege set to be able to edit a record in this table such as:

          BdFt > 0


          You may want to repeat this for the Delete drop down if you also want to use the same logic to control whether or not the record may be deleted.

          • 2. Re: Locking a Record

            I don't see the "Custom Privileges" or Records Drop down.


            I'm running FM Pro 13 Advanced, the choices that are available in "Manage Security" are;


            Privilege Set

            Extended Privileges

            File Access

            • 3. Re: Locking a Record

              It's there. Choose the option to edit the account's privilege set.