Announcement

Collapse
No announcement yet.

Automatic Lookup, add value

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Automatic Lookup, add value

    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

    Comment

    Working...
    X