1 Reply Latest reply on Jul 2, 2009 1:42 PM by ninja

    Conditional field locking

    frog22

      Title

      Conditional field locking & unlocking

      Post

      Given

          Table A

              Field "Measurement 1"

              Field "Measurement 2"

             Field "Measurement 3"

       

       

      Is there any way to have a field "Measurement 3" locked until a condition such as (If "Measurement 1" - "Measurement 2" >= 1) then unlock "Measurement 3" so that a 3rd measurement can entered?  Thanks!

        • 1. Re: Conditional field locking & unlocking
          ninja
            

          Howdy frog22,

           

          Your previous post:

          Locking a field (promise this one is different from the others)

          probably seems like a different topic to you...but as you understand conditional privileges, you'll find that they work in a number of ways.

           

          Please see the answer in your other post (link above) and use the "limited..." calculation of

           

          Measurement1 - Measurement2 >= 1  ("greater than or equal to" intended)

           

          or whatever other calculation best describes the situation where the user CAN edit the field.

           

          Then take a breather and think of all the awesome ways conditional privileges can be used to help you (and royally P.O. the next person who has to support the database in day to day operations...don't go overboard, just use what is needed)

           

          Enjoy the July 4th holiday if it applies!