ValueListIDs()

ValueListIDs()

Category: Design

Syntax: ValueListIDs ( fileName )

Parameters: fileName ”a string or text expression that represents the name of an open file.

Description: Returns a carriage return “delimited list of value list IDs from the specified file.

Examples:

 ValueListIDs (Get (FileName)) 

Returns a list of value list IDs for the current file that might look like this:

 21 92 90 108 15 

Comments:

FileMaker assigns a serial number to each value list created in a file. The order of the list returned by the ValueListIDs() function is the same as that in which the value lists are ordered in the Define Value Lists dialog when the order is set to Custom Order. Changing the Custom Order changes the way the results are ordered, but selecting one of the other choices (Creation Order, Source, Value List Name) does not affect the order.