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.