in one of the most recent threads I saw something interesting
to avoid inadvertent data changes I think it is necessary to commit when ready by a submit/save button. and someone suggested a a series of staging tables with a save script
has anybody done that and if how?
I have in the past played with duplicating every layout into a edit and view layout but that has horrible maintenance issues.
also if I inadvertently change a value there is no restore.
also the data should be validated to comply business rules!
does anybody have anything to enlighten me.