ValueListItems()

ValueListItems()

Category: Design

Syntax: ValueListItems ( fileName ; valueListName )

Parameters: fileName ”a string or text expression that represents the name of an open file; valueList ”the name of a value list in fileName .

Description: Returns a carriage return “delimited list of the items in the specified value list.

Examples:

 ValueListItems (Get (FileName);"Phone_Label") 

Returns a list of values from the value list Phone_Label in the current file that might look like this:

 Home Work Cell Fax 

Comments:

The ValueListItems() function is often used to consolidate information about a set of related records. For instance, in an invoice file, you might have a value list called Products_Ordered that's defined to return the ProductName field from a related set of records in the InvoiceItem table. ValueListItems (Get (FileName); "Products_Ordered") would return a list of all the products ordered on the current invoice.