Autocomplete problem

[Alberto]

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

[Bruce]

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