"I'd love to hear what others do when they need to use this "transactional" model for their database."
An old trick consist to put a big button ( so big as the layout ) under all those fields.
A newer one is to put a Web Viewer under those fields.
Not sure about the Web Viewer solution, but putting the button on those three fields might work, except for one problem: I use Lookup Values on those fields (in the Manage Database AutoEnter screen). So much of the time, the user never touches those fields.
Not "on", but "under" !
A button that do only : Go to field [ firstField ]
But it's better the Web Viever ( empty ) solution.
( you have to uncheck the: "Save record changes automatically" box into the tab General of Layout >> Layout Setup )
How does the blank Web Viewer help?
as you know, FileMaker saves the record automatically, clicking on the layout...
If you uncheck the: "Save record changes automatically" box, FM will shows the also known annoying message...
So the idea is to put an empty invisible WV under all the fields of that layout ( a wv of the same dimensions of the layout ).
When the user clicks the layout, nothing happens ( no more the message ) so you could save the changes forcing the user to press a button with you script attached.
I see. That works, except for one problem. If the user enlarges the window so that it's bigger than the layout, then when they touch the mouse pointer outside the layout, but still inside the window, the irritating message about saving the record appears.
... but not if you set the object ( WV ) with 4 anchors ! :smileywink:
Thanks for taking the time on this, Daniele. Setting 4 anchors seems to solve this problem.