When you utilize maintenance applications for your end users, you will, more likely than not, want to record when and who have made changes to your data. Doing this with mrc is a breeze.
After you have selected the appropriate files and fields and have set up your sequencing, click on the “Application Options” -> “Field Settings” link.
Change the “Basic field attributes” dropdown to “Form validation and auditing”.
In the Audit column is a selectable drop-down that will only appear for any non-numeric fields. Selecting a value from this drop-down will have your application automatically insert a date for when the record is submitted or updated. Aside from a date, you may also audit the user, time or the application program (which will record the application number, such as M00001).
The drop-down options are as follows:
‘Change (Date/Time/User/PGM)’ will audit when an existing record is updated.
‘Add/Change (Date/Time/User/PGM)’ will perform both of the above.
Any fields that are have an audit option applied will be automatically hidden from the maintainer form at run-time when viewing a record in add, update, or delete mode.