Help

Editing objects, layout parts, and the layout background
F
ILEMAKER PRO HELP 343
3. In the Manage Value Lists dialog box, click OK.
Notes
• If you want a field to always use the values in the value list, no matter what layout the fields
object is on, specify a validation option in the field’s definition. See
Defining field validation.
• If the value list you’re defining contains dates, make sure the values contain four-digit years
such as
6/29/2014 instead of 6/29/14. During data entry, a date field formatted to
display a value list containing two-digit year dates will convert them into four-digit years as
described in
Conversion of dates with two-digit years.
• Fields from ODBC data sources can be used in value lists, but character large objects
(CLOBs) such as long text strings are not supported.
• For value lists with ODBC data, the No access privilege and Limited custom privilege are
not supported. To prohibit a user from seeing ODBC data in a value list, you must enforce
row-level security in the external SQL database. See
Editing value list privileges.
Setting up a field to display a pop-up menu, checkbox set, or other
control
You can make data entry for a field easier and more consistent by displaying fields as drop-down
lists, pop-up menus, checkbox sets, radio button sets, or other controls.
You can set these controls at the same time you place fields on a layout, or you can modify existing
field controls. For more information on placing fields on a layout, see
Placing and removing fields on
a layout.
Note Values displayed in these controls come from value lists. You can define a value list before or
after you set up the field controls.
To set up a field to display a pop-up menu, checkbox set or other control:
1. In Layout mode, select the field.
2. Click Inspector in the layout bar, then click Data.
3. In the Field area, choose the Control Style you want.
To Do this
Change the values in a value list
or how the values in a dynamic
value list are generated
In the list of value list names, select the value list, then click Edit.
In the Edit Value List dialog box, make changes. Then, click OK.
Note Redefining a value list item after data has been entered
might cause unexpected results. For example, if you change a
value list item from Accessory to Accessories, the field will
appear to be empty on layouts where the field is formatted as a
checkbox or radio button. Also, you will not find the existing
records if you search for Accessories.
Duplicate a value list In the list of names, select the value list, then click Duplicate.
Delete a value list In the list of names, select the value list, then click Delete. In the
confirmation dialog box, click Delete again.