Help

Editing objects, layout parts, and the layout background
F
ILEMAKER PRO HELP 341
1. Choose File menu > Manage > Value Lists.
In Layout mode, you can also click Manage in the status toolbar, then choose Value Lists.
2. In the Manage Value Lists dialog box, click New.
3. In the Edit Value List dialog box, for Value List Name, type a name.
4. Select Use values from field.
5. In the Specify Fields for Value List dialog box, for Use values from first field, select the
table that contains the field you want, and then select the field in the list.
If the table you want is in another file and does not appear in the list, choose Manage Database
from the list, and add the table to the relationships graph. See
Creating relationships.
6. Choose whether to display all the values in the field or only related values:
• To include all the field values in the value list, choose Include all values.
• To include only related values in the value list, choose Include only related values
starting from, and choose a related table from the list. The value list will only display
field values from records that satisfy the relationship criteria specified between the
related table and the table containing the field selected in the Use values from first
field list.
For an example of a value list that displays only related values, see Example of a value list that
includes only related field values.
7. To also display associated values from a second field, select Also display values from
second field, select the table that contains the field you want, and then select the field in
the list.
Select this option to display the values from a corresponding field after the values in your value
list. For example, to help with data entry, you could display part names next to part numbers. If
Also display values from second field is dimmed, first select a field in the left field list, as
described in step 5.
Note During data entry, a value list that displays values from two fields still only enters data
from the first field specified in step 5. The second field in the value list is for display only, and its
value is not entered into any field. However, you could use a lookup to automatically enter the
data from the second field. See
About lookups.
8. If you selected a second field to display values:
• Choose which field to use for determining the value list sort order.
• Choose Show values only from second field to display values from the second field,
but store the data from the first field.
If you choose not to select Show values only from second field, the value list will display both
fields, for example, a pop-up menu displays both fields.
Summary of Show values only from second field behavior:
Field/control Behavior
Radio Button set, Checkbox set, Pop-
up menu
Only the value from the second field is displayed. When
you make your selection, the corresponding value from the
first field is stored in the database.
Drop-down list The field displays the value from the first field. When you
click in the field, the drop-down list displays values from
the second field. After a selection, the list again displays
the value from the first field when the field is exited.