Lock a record

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.

You can also do this through the permissions set.  Goto the specific table in the "edit" portion of the permissions dialog and set it to limited.

Once you do this you will automatically get a calculation screen.  You calculation should read...

Case(your_table::status = "complete" ; 0 ; 1 )

This will result in a generic fmp error message letting the end user know they can not edit this record.

You can expand the functionality of this with a free plugin called eventscript (http://www.softs4humans.com/FMPro_Plugins.html)

This plug in will allow you to trigger a script that informs the user why the can not edit the record.  

Your calculation would then look like this

Case (your_table::status = "complete" ; 0 & S4HU_EventScript( get (filename) ; "permissions error" ; "" ); 1)

This would trigger a script titled "permissions error".  In that script you would have a custom dialog explaining to the user why the record could not be edited.   

I've used this solution for a job tracking system that locks a record after delivery or invoicing from being edited by producers (but is still editable by other users that have a different permissions set)

Hope this helps