Reference > Functions reference > Design functions > ValueListItems
 
ValueListItems
Purpose 
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.
Examples 
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