Database Driven Auto-Complete

[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 (9.41 KiB) Viewed 2682 times

[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?

[brianhd71]

Yes. That is exactly what I am looking for.

[brianhd71]

How do I get the code to display instead of the description?

[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.

[brianhd71]

I used a combo box to get the result I wanted.

Thanks..