Value list from field with custom values added

[Matt Malyschko]

I want to create a value list from the records in a table. I also want to add the value 'All' to this value list as it will be used in a filter selection.

 

How do I achieve this?

[LaRetta]

Usually you would create a calculation ( result is text ) which concatenates the field value you are indexing as:

theField & CR & "_All_"

... where CR is the pilcrow ( I can't make it on the iPad).

Then reference this calculation in your value list instead of the original field. :-)