Page 1 of 1

Database Driven Auto-Complete

Posted: Mon Jan 04, 2016 11:39 am
by brianhd71
Is there a way to search on one value on auto-complete and bring another value back to the text-box? I want the user to be able to search on a description and retrieve the code, but it does not look like that is possible. I have WACODE in the choice values field thinking it should retrieve that code, but it does not.
Capture.PNG
Capture.PNG (9.41 KiB) Viewed 2804 times

Re: Database Driven Auto-Complete

Posted: Tue Jan 05, 2016 10:32 pm
by Scott Klement
The way you've set this up, it should display the WADESC, WACODE values on the screen, but store the WACODE value of the chosen item into whatever is bound to the 'value' property of the widget.

Is that what you're looking for?

Re: Database Driven Auto-Complete

Posted: Wed Jan 06, 2016 5:12 pm
by brianhd71
Yes. That is exactly what I am looking for.

Re: Database Driven Auto-Complete

Posted: Wed Jan 06, 2016 6:46 pm
by brianhd71
How do I get the code to display instead of the description?

Re: Database Driven Auto-Complete

Posted: Thu Jan 07, 2016 10:08 am
by Scott Klement
You can make it display both the code and the description, but you can't make it display just the code. The users typing needs to match what it is typing in the box... that's what autocomplete is all about.

Re: Database Driven Auto-Complete

Posted: Thu Jan 07, 2016 3:47 pm
by brianhd71
I used a combo box to get the result I wanted.

Thanks..