Reference > Functions reference > Design functions > ValueListItems
 

ValueListItems

Returns a list of the values in a value list.

Format 

ValueListItems ( fileName ; valueList )

Parameters 

fileName - the name of an open database file, (local or remote).

valueList - the name of a value list in the specified database file.

Data type returned 

text

Originated in 

FileMaker Pro 6.0 or earlier

Description 

Listed items are separated by carriage returns.

Notes 

In FileMaker WebDirect, this function supports returning results from the current file. If fileName references a different file, this function returns an empty string.

Example 1 

ValueListItems ( "Customers" ; "Code" ) returns a list of all the items in the Code value list in the Customers database file.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas