Help

Creating a database
F
ILEMAKER PRO HELP 180
7. Click OK to close the Options for Field dialog box, or click another tab to set additional field
options.
Notes
• You can also define value lists to save time and ensure accuracy during data entry.
• Alternatively, you can specify the auto-complete option for text fields to help ensure
accuracy for data entry. See
Setting up a field to auto-complete during data entry.
• Your choices in the Options for Field dialog box are limited by the type of field you are
defining. For example, you can't choose Creation Date for a time field.
• If Creation Name or Modification Name is selected, FileMaker Pro enters the user name
shown in the General tab of the Preferences dialog box.
• If you select Calculated value, you can edit the field value in Browse mode (if Prohibit
modification of value isn't selected). The value is calculated when you create a record, or
Enter the record modification date and time
(timestamp)
Select Modification, then choose Timestamp from
the list.
Enter the name of the person who modifies
the record
Select Modification, then choose Name from the list.
Enter the account name that modifies the
record
Select Modification, then choose Account Name
from the list.
Assign a serialized number to the field in
each record
Select Serial number, then:
• For Generate, choose On creation to generate
serial numbers when records are created.
• For Generate, choose On commit to generate
serial numbers when records are committed.
For next value, type a starting value (like 100), then
type the increment in increment by.
Enter the value from the same field of the last
record you accessed
Select Value from last visited record.
Note This value will be from the last record accessed
in the table in which this options has been set.
Enter data that you specify Select Data, then type up to 255 characters. Use the
keyboard arrow keys to scroll through the text box, if
needed.
Enter the result of a calculation Select Calculated value (or click Specify), then
enter a calculation.
See Defining calculation fields for information about
the dialog box.
Select Do not replace existing value for field (if
any) to prevent overwriting data already present.
Enter a value that's copied from a field in a
related record
Select Looked-up value (or click Specify), then
define the lookup. See
About lookups.
Prohibit a user from modifying a value that
you have defined to be auto-entered
Select Prohibit modification of value.
Turn off automatic data entry Clear all selected checkboxes.
To Do this