Help

Table Of Contents
Adding and viewing data
F
ILEMAKER PRO HELP 104
If the values are from a field in another table, check the relationship (make sure it is valid
and contains values). For more information, see
About relationships.
If the value list uses values from another file, the file may have been moved or renamed, or
your access privileges may not allow you to access it.
Items or characters are missing from the value list
If the value list is obtaining its values from a field, make sure the field type matches the
values you’ve entered. For example, if a number field contains values without numeric data,
these values won’t be indexed, and any value list based on that field won’t display the non-
numeric values.
If the value list is defined to display information from two fields, items will not be duplicated
for the field on which the value list is sorted. For example, if the value list displays
information from the Company field and the Name field, and if the values are sorted by the
Company field, only one person from each company will appear in the value list.
If certain characters within value list items are missing or display as squares, make sure the
font you select for the field object is capable of displaying all the characters in your value
list, particularly if your values contain multiple languages or character sets. For more
information, see
Specifying text formats for fields.
Error: Invalid Value List Usage
If a field is formatted to use an external value list that is defined to use related values, the
field and value list must be defined in the same file. The field must be a related field from the
same file.
Value list displays <no values defined>
If the value list uses values from a field in another file, the file has been moved or renamed
or your access privileges don’t allow you to access it.
Related topics
Defining value lists
Setting up a field to display a pop-up menu, checkbox set, or other control