Announcement

Collapse
No announcement yet.

Autocomplete

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

  • Autocomplete

    Hi, Is there any possibility to use the autocomplete using one table?
    I have a table with CustomerID = int and Customer Name = varchar and need to use autocomplete in the Customer name.

    Thanks

  • #2
    Yes, afaik if you create a text autocomplete then you have to supply a sql query defining the key and the field to be shown. The select is used on the field to be shown.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Thank for the reply. I already did but still having the ID number instead of the name...

      Comment


      • #4
        i tried a number autocomplete and it works well. The number is hidden, but the description is shown...

        I made a small movie to show you, it's soundless by mistake, but I think it is clear enough.

        http://scriptcase.eu/demos/demolookup.html
        Last edited by aducom; 02-05-2013, 05:57 PM.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment


        • #5
          Plenty of thanks Aducom. It's a great help.

          Comment

          Working...
          X