I have a layout that is used for data entry. I have setup a field named "Locked" with a radio button of yes / no. I would like for my clients to be able to lock the record by clicking the yes button, thus preventing data being corrupted accidentally by overwriting existing data. If the record needs to be edited then the client would unlock by clicking the no button. I know this could be done with conditional formatting for each field but I feel that there is a better solution.
I am quite new to FM and really enjoy the power and simplicity of the database. I would appreciate any suggestions or solutions.