Howdy --

I want to force users to "submit" changes to records, instead of having

changes automatically written to the database? Using a second field(s) to hold the data before hitting the sumbit button is one option?

TIA,

Dave

Using a second field(s) to hold the data before hitting the sumbit button is one option?

Yes. Global fields are often used for this when creating new records.

You could do something similar for editing existing records.

Users would be required to hit a button if they want to make changes, which would take them to a layout with all global fields. Values from the regular fields will have to have been set in the global fields. After making changes, a button would set these values back to the fields in the record, then clear the globals.

You need to make sure users cannot change records while entering data in the globals.