Revert Record and Field Validation do not work in conjunction with each other
In my limited experience I have found that Revert Record and Field Validation under Manage Database do not work in conjunction with each other.
Since there are only 2 options under Validation, "Always" or "Only during data entry" that means whenever you click outside a field once data has been entered, the data is commited to that record. If at this point you then Revert Record and go back to the state before the data was entered in that field, I found that the data is still there meaning the Revert Record doesn't work.
Does anyone have thoughts on how to get it to work? The reason I ask is that I have one layout for display, and another for editing that info. If I am on the edit layout and realise I have made a mistake entering data I want to click a cancel button (revert record) to take me back to the original state so I can start again. The same goes for an automatically generated ID number, if the number is generated then I want to revert the record, that ID number still exists.