I have "Save Record Changes Automatically" unchecked because I want to be able to revert a record. Daniel Shanahan has made a helpful video (http://www.youtube.com/watch?v=QTCqzysiQWA) to show one trick about how to prevent records from being committed when users click somewhere on the layout. The problem I'm having is that when the user selects a value in one field, a SQL script runs that gets the related records for that value and places them in a ValueList set to a field. Unfortunately, while those values appear in the debugger, they don't appear in the value list without a Commit Record. So without a commit record the values don't appear. With a commit record they do appear, but then I can't revert the record.
What is the solution to the conundrum? I'm trying to avoid relationships, but I guess I'll put on in to see if that will solve this issue.