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

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.

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

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

Plenty of thanks Aducom. It’s a great help.