List ( FieldInThisTable ) will return data from the same record only.
List ( Related::Field ) will return a list of all non-empty values in related records; if only one value is returned, then only one record is related.
There is no native function to return a list of values in the current found set.
If I understand correctly, the LIST function is supposed to return a CR-delimited list of each unique value found in a field - sort of an index for the field.
No, that is not correct. However, you can define a value list based on the field and get a list - unique and sorted - by using the ValiueListItems() function. This will indeeed draw on the index for the field (ignoring any found set).
Message was edited by: Michael Horak
1 of 1 people found this helpful
No, that is not at all what the list function does. The list function has nothing to do with uniqueness. It collects ALL vaues across the relationship or list of fields that you provide.
Your screen shot doesn't provide much help. It doesn't show anything about how you are trying use the function.
In general it is more helpful to provide a lot more detail when trying get answers to questions.
Can you post a copy of your file or create a simplified example of what your are trying to do and post that?