November 11, 201213 yr 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?
November 11, 201213 yr 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. :-)
Create an account or sign in to comment