In order to prevent that users with limited knowledge
about Compiere and databases accidentally overwrite a
record I suggest that a Window can be opened in a mode
where it is "Edit Mode Restricted".
When a Window is Edit Mode Restricted all fields as a
default are inactive and cannot be edited. Only after
pressing a button on the menu will all fields become
active and normal editing can take place.
The fact that a user must actively decide that he wants
to update a record will help prevent accidental
overwriting of data.
This solution has been implemented in the compierecms
project by introducing a column called
"IsEditModeRestricted" in tables "AD_Tab" and "AD_Role".
A tab is only restricted if both the AD_Role and the
AD_Tab are ticked as being Edit Mode Restricted.
I suggest this improvement is implemented in the
standard Compiere version.