User manual

Adding and viewing data 2-11
6. Click Replace.
Note If the field that contains the replaced data is validated,
FileMaker Pro doesn’t validate the new data. See “Defining field
validation” on page 5-9.
To add a prefix or suffix to values in a field, see FileMaker Pro help.
Choose Help menu > Contents and Index, click the Index tab, and type
prefixes.
About working with graphics,
sounds, and movies
You can use container fields to store multimedia, like graphics,
sounds, or movies. In Windows, you can also store Object Linking
and Embedding (OLE) objects in container fields. See “Working
with OLE objects” on page 2-15.
Keep these points in mind:
1 To create a container field, see “Defining text, number, date, time,
or container fields” on page 5-5.
1 Windows: If you’re inserting or pasting graphics into a database
that you share with FileMaker Pro for Macintosh users (for example,
if you’re sharing the database on a cross-platform network), make
sure Store compatible graphics is selected in the General tab of
Document preferences. See“Setting general application preferences”
on page A-1.
1 To control how graphics display in a container field, see
“Formatting graphics on a layout” on page 7-17.
1 For more information, see FileMaker Pro Help. Choose Help menu
> Contents and Index, click the Index tab, and type container
fields.
Inserting graphics into fields
1. In Browse mode, click a container field.
2. Choose Insert menu > Picture.
3. In the dialog box, choose a file type for Files of type (Windows) or
Show (Mac OS).
Tip You can use the Insert QuickTime command for file types
supported by QuickTime 3.0 or later. See the following section if you
can’t find the file type you want.
4. Select the graphic file (change folders, if needed).
5. Choose a storage option, then click Open.
A serial number Replace with serial numbers. Type the starting value for
the serial numbers in Initial value, and the incremental
value in Increment by. (FileMaker Pro enters serial
numbers starting with the first record in the found set).
If the field is defined to automatically enter a serial
number, you can:
1 Select Update serial number in Entry Options to reset
the next value in the Options for Field dialog box. The
next automatically-entered value for this field (after
the replace is performed) follows in sequence.
1 Clear Update serial number in Entry Options to leave
the next value in the Options for Field dialog box
unchanged. The next automatically-entered value is
based on the current settings (not in sequence with
records reserialized by this replace task).
For information about the Options for Field dialog
box, see “Defining automatic data entry” on page 5-8.
A calculated value Replace with calculated result, then click Specify. In the
Specify Calculation dialog box, define the calculation.
The result must match the field type of the replaced
field. Click OK.
For information about the Specify Calculation dialog
box, see “Defining calculation fields” on page 5-5.
To replace each
field with Select