QUE CORPORATION - Using Filemaker pro X

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.