Database Reference
In-Depth Information
Figure 6-2. Top: The Manage Database window's field list shows auto-enter options in the Op-
tions/Comments column. The “modStamp” field tracks the date and time that any field in a record
gets changed. In conjunction with the “modifier” field, you can figure out who's entered stuff into
this record and when. Bottom: This layout shows four auto-enter fields that store information about
who creates and modifies each record and when they do so.
On the “Options for Field” dialog box's Auto-Enter tab, the first two auto-enter options (cre-
ation values and modification values) let you create and maintain metadata. Many developers
find these fields so useful for peeking behind the scenes that they create primary key fields
and the four metadata fields shown in
Figure 6-2
in each table before they create any other
fields.
