User manual

Setting options for fields | 93
5. In the Options for Field dialog box, click the Auto-Enter tab and select
options. (The available options depend on the field type.)
To Do this
Enter a date, time,
timestamp, user name, or
account name when the
record is created or
modified
Select Creation or Modification, then choose an option from the
list.
Assign a sequential
number to the field in each
record
Select Serial number. Select On creation to assign the number
when a record is created. Select On commit to assign the
number when the record is committed. For next value, type a
starting value (for example, 1001), then type the number to
increment by.
Enter the value from the
previously accessed record
Select Value from last visited record.
Enter data you specify Select Data, then type up to 255 characters.
Enter the result of a
calculation in the field
Select Calculated value, define the formula in the Specify
Calculation dialog box, then click OK. For more information
about the Specify Calculation dialog box, see
“Defining
calculation fields” on page 85.
Select Do not replace existing value of field (if any) to prevent
overwriting data already present.
Enter a value that’s copied
from a field in the same or
a different table or file
Select Looked-up value, define the lookup, then click OK. See
“Creating lookups” on page 151.
Prevent users from
changing an automatically
entered value
Select Prohibit modification of value during data entry.
Turn off automatically
entered data
Clear all selected checkboxes.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 93 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ