User manual

7-4 FileMaker Pro User’s Guide
4. Define the value list:
5. In the Define Value Lists dialog box, click Done.
To Do this
Define static values
for the value list
Select Use custom values, then type each value on a
separate line, in the order you want them to appear.
Press Enter (Windows) or Return (Mac OS) to separate
each value.
Create values
dynamically from all
the values in another
field in the current file
or in another file
Select Use values from field. In the Specify Fields for
Value List dialog box:
1 To use a field from the current file, make sure All
values is selected, then in Use values from this field,
select the field name.
1 To use a field from a different file, click Specify File,
then choose a filename and click Open. Make sure All
values is selected, then in Use values from this field,
select the field name.
If you want to display values from a second field, see
“Also display associated values from a second field,”
later in this table. Otherwise, click OK.
Create values
dynamically from a
subset of values in
another field (the
subset is determined
by a relationship)
For more information,
see “About displaying
only a subset of field
values in a value list”
on page 7-5.
Select Use values from field. In the Specify Field for
Value list dialog box, select Only related values and
choose or define a relationship from the relationship
list. Then, in Use values from this field, select the field
name.
If you want to display values from a second field, see
“Also display associated values from a second field,”
next in this table. Otherwise, click OK.
Also display
associated values from
a second field
Follow the instructions in one of the previous two table
rows. Then, click Also display values from and select a
field name. Select this option to display the values
from a corresponding field next to the values in your
value list. For example, to help with data entry, you
could display part names next to part numbers.
You can also choose which field to sort the value list
by if you’re not using Only related values. To display
both values sorted by the values in the first field, select
first field for Sort value list by. To base the sort on the
values in the second field, select second field. If you
choose first field, duplicate values will not display for
the first field; if you choose second field, duplicate
values will not display for the second field.
Click OK.
Use a value list
defined in another
FileMaker Pro file
Select Use values from another file. In the Specify
External Value List dialog box, click Specify File, then
select a filename and click Open. For Value List, choose
or define a value list, then click OK. In the Edit Value
List dialog box, click OK.
To Do this
Select a second field
to display values from
Use all field values
Select a field to
use its values
Display only related
field values