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.
Important  See Design functions for information about literal text parameters.
Data type returned 
text
Originated in 
FileMaker Pro 6.0 or earlier
Description 
Listed items are separated by carriage returns.
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