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
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.
Plenty of thanks Aducom. It’s a great help.