List function

[Rick Whitelaw]

It's my understanding that the List function (across a relationship) should return a list of unique values. In other words, no duplicates. Apparently this is not the case. Instead I'm using Brian Dunning's UniqueValues CF to achieve this end. What's up with that?

[bruceR]

List returns the list.

It has nothing to do with unique values..

[bruceR]

But if you want to define a value list that shows only related values, define a value list that shows only related values.

You don't need a custom function.

 

Example of a value list that includes only related field values

[comment]

But if you want to define a value list that shows only related values, define a value list that shows only related values.

 

I don't see the purpose of defining a value list anywhere in the question. Granted, using a value list in order to get a list of unique values (through the ValueListItems() function) is bound to be more efficient than any custom function. However, this can only work if the field in question is indexable.

[Rick Whitelaw]

Thanks guys. Not sure why I thought List returned unique values. I've certainly used the function often enough . . .