U.M. (Mac OS)

Creating a database file 2-7
1 To make the field a repeating field, select Repeating field with a
maximum of
n repetitions, and then type the number of repetitions.
(See “Defining repeating fields” on page 2-11.) To set options for
indexing the field’s values, click Storage Options, and then select
indexing options. You can also choose a language for indexing and
sorting text fields. (See “Indexing fields” on page 2-12.)
5. Select options for automatically entering and validating data.
For To Do this
Auto Enter Turn off automatically entered data Select Nothing.
Enter the date, time, or user name
when the record was last created or
changed
Choose an option from the pop-up
menu.
Assign a unique, sequential number
to the field in each record
Select Serial number, and then type a
starting value (for example, 1001)
and the number to increment by.
Enter the value from the previously
accessed record
Select Value from previous record.
Enter data you specify Select Data, and then type the data
you want, up to 255 characters.
Enter the result of a calculation in
the field
Select Calculated value, and then
define the formula. (See the note at
the end of this section and
“Understanding formulas” on page
2-13.)
Enter a value that’s copied from a
field in the same or a different file
Select Looked-up value, and then
define the lookup. (See “Defining
lookups between files” on page
10-11.)
Prevent users from changing an
automatically entered value
Select Prohibit modification of value.
Validation Check that the data is a number,
date, or time
Select Of type and then choose a type
from the pop-up menu.
Check that the field is not empty, or
that the value is unique or already
existing in the file
Select Not empty, Unique, or Existing.
Check that the value is in the value
list you specify
Select Member of value list, and then
choose a value list from the pop-up
menu, or define a value list. (See
“Defining value lists” on page 3-75.)
Check that the value falls within the
range you specify
Select In range, and then type a
starting value and ending value for
the range.