I have two fields Client Code and Order No. I want to do something like this in FileMaker(15). If ClientCode = 111 then dont allow user to update/modified order no value. Is it possible to add restriction something like this ?
you could stack an Edit Box and a Merge Field of the same data; and then use Hide Object When condition for one, and not condition for the other.
In your Privilege Set you can set behaviour based on Calculation.
FileMaker 15 Security Guide: Best Practices for Configuring Security Options
Often, the best solution is to combine David and Johan's methods. Use access privileges to make sure that values cannot be edited when they should not be, then use an interface design such as David's to get a better user experience where the user is never allowed to attempt an unauthorized change only to get an access privileges error.
Retrieving data ...