Automatic Lookup, add value

Applications Forms
#1

Hi,

i have automatic lookup on field. Is it possible to add a value in the list ?
List (select field from table) : Red, Green, Black.
I wish to add the value “ALL”.
New List : Red, Green, Black, ALL

Thanks !

J’ai un lookup automatique sur un champs. Est-il possible d’ajouter une valeur dans la liste ?
Liste (select field from table) : Red, Green, Black.
Je souhaite ajouter la valeur “TOUS”.
Nouvelle liste : Red, Green, Black, TOUS

Merci !

#2

You can do it with a UNION. Select color from mytable UNION select ‘ALL’ from mytable