7 Replies Latest reply on Sep 2, 2014 9:06 PM by samarthmkt

    Lock and unlock the record


      Hi FileMaker Members


      I have a question about how to creat a script to limit the modification permission of the record. The details as below.


      For example, there are some fields in the named "orders" layout including a field Approval Status with value list by "Approved" and "Draft".

      When I set the field Approval Status as "Approved", the related record of the orders layout was locked or unable to edit. On the contrary, "Draft" can be modified.

      Attached GUI for your reference.


      Hope I make myself clearly. Look forward to hearing from your reply. Thanks in advance.