11 Replies Latest reply on Sep 16, 2015 9:09 PM by Extensitech

    Value list from table plus one extra value

    dinoapolito

      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