NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Alberto on May 29, 2019, 03:11:28 AM

Title: Autocomplete problem
Post by: Alberto on May 29, 2019, 03:11:28 AM

Hi, Im using autocomplete to retrieve the ID value of a table showing and ordering by the NAME field
When I use it in a table with an ID index and a NAME index it works ok but... I have tables in which the NAME index is defined as NAME,ID ... in that case autocomplete does not work.
I dont know why this indexes are that way because this is not my dct.

Am I obligued to have a new index as NAME (without ID)  or is there any way of workarround this?

And if I ADD this index, will the template choose it ok discarding the NAME,ID index and choosing NAME index?

Thanks

Title: Re: Autocomplete problem
Post by: Bruce on May 29, 2019, 10:10:56 PM

Ideally you want to add a key to the table with just the Name attribute.

It does sound as if the name though is not unique - which may be an issue if you are auto-completing on name since then the user can't tell between one name and the other.

cheers
Bruce