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
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
I can then trap that and perform the ensuing search on all accounts not just a particular one.
Can anyone think of a way?