Title
Lock a record
Post
Apologies if this has been asked before - I cannot find a solution to something I hope is relatively simple.
I am creating a ToDo list using FM10 and when a User selects 'Complete' from a drop-down list, I want to lock the record so that it is no longer editable. I still want to be able to view the record.
Thanks for your help in advance.
Mark
Hi Mark,
There is probably an easier way to do this with triggers in FMP 10; but until someone posts it here this may help.
For each edited field on your layout, set the Validation option to Validate by calculation. In the specify dialog check that the drop-down list is not equal to 'Complete'. Also deselect the 'Allow User to override' checkbox.