FileMaker Talk Podcast
Have you ever wanted to prevent a record from being committed when a user clicks on the layout? There are various reasons you might want to do that. In my recent scenario, I wanted to allow users to create records in the Request table, but not view or edit them. I set up my security like so:
This setup functions as a sort of drop-box — in the Request table, users can create a record, but that’s all. They can’t go back and look at their data or that of other users. Note: the user can enter and edit data in fields, as long as the record has not yet been committed.
The one problem with this is that if a user accidentally commits the record they’ve created, for example by simply clicking on the layout outside a field, they will lose the ability to edit or even view the layout they were just working on.
FileMaker Talk Podcast