User manual

7-4 FileMaker Pro User’s Guide
4. Define the value list:
To Do this
To Do this
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.
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.
Use a value list Select Use values from another file. In the Specify
defined in another External Value List dialog box, click Specify File, then
FileMaker Pro file 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.
Use all field values
Display only related
field values
Select a field to
use its values
Select a second field
to display values from
Create values Select Use values from field. In the Specify Field for
dynamically from a Value list dialog box, select Only related values and
subset of values in choose or define a relationship from the relationship
another field (the list. Then, in Use values from this field, select the field
subset is determined name.
by a relationship)
If you want to display values from a second field, see
For more information, “Also display associated values from a second field,”
see “About displaying next in this table. Otherwise, click OK.
only a subset of field
values in a value list”
on page 7-5.
5. In the Define Value Lists dialog box, click Done.