Announcement

Collapse
No announcement yet.

Select That Also Accepts Manual Entry Like If Defined as Text Data Type

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

  • Select That Also Accepts Manual Entry Like If Defined as Text Data Type

    Is there a way to enable a Select field to use an Automatic lookup method to show distinct field values and also allow manual entry in the event the desired selection is not already present in the table? For example, a table column may already have many entries of items like Dog, Cat, Bird. The lookup method is automatic, and a hypothetical SQL select statement is:

    SELECT DISTINCT Animal
    FROM zoo
    ORDER BY Animal

    Without creating another application, how might I enter a new animal like Cow if Cow is not already a Select option?

  • #2
    You cannot do this with type SELECT.

    But there is a workaround if you are using Type TEXT AUTO COMPLETE. Supposed your select data only contains only DOG, CAT and RAT inside the database, now you want your form to accept MOUSE, to achieve this, check my screenshot attached.

    autotextbox.jpg

    Comment


    • #3
      workaround is not working for me. I get an error since the testname field could be empty.

      but another way is
      • use auto text complete + normal lookup
      • enable the capture text
      now you can enter a value or choose one from the list

      Comment

      Working...
      X