AnsweredAssumed Answered

Value list from table plus one extra value

Question asked by dinoapolito on Sep 15, 2015
Latest reply on Sep 16, 2015 by Extensitech

Hi,

 

I want to make a value list from an Accounts table that will be used in a lookup field. That's easy - the user can select a particular account from the drop down list and it all works well. For example

 

Acme

Apple

Argo

 

and so on....

 

However I have a need for the user to select "All" accounts rather than a particular account. I therefore wanted the value list to list ALL accounts but additional something like a * or an "ALL". For example

 

*

Acme

Apple

Argo

 

I can then trap that and perform the ensuing search on all accounts not just a particular one.


Can anyone think of a way?


Thanks

Dino

Outcomes