How do I stop additional data entry to a record? 1

[dmurnane]

I have a database that is used to monitor maintenance callouts to various buildings, these records are classified as either 'open', 'pending' or 'closed' from a drop down field menu. When the field is changed to 'closed' how can I prevent all the rest of the data in the record from being modified?
Many Thanks,
Dominic

 

[gmannatl]

There is no right or wrong way to accomplish this. Depending on how much flexiblity you want will determine what is best for you. The quick down and dirty way would be to use FM built in security. Go to Manage - Accounts and Privileges. What you need to do is create a new privilege set. Assign it a name and then on the Records drop down choose custom. You can then set the access levels for each table in the database and for edit select limited and you can build the expression for when it is ok to edit.

Then simply create the users and assign them this set.

Alternatively, you could use scripting to change the field to closed, and use separate layouts where the fields can not be entered in the "closed" layout. You can get pretty creative with using different portals and relationships to display the data differently depending on the "status".