Database Driven Auto-Complete
-
- Profound User
- Posts: 36
- Joined: Thu Jan 02, 2014 6:20 pm
- First Name: Brian
- Last Name: Lannoye
- Company Name: Dealertrack Technologies
- Phone: 801.617.1806
- State / Province: Utah
- Zip / Postal Code: 84095
- Country: United States
- Contact:
Database Driven Auto-Complete
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.
-
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Database Driven Auto-Complete
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?
Is that what you're looking for?
-
- Profound User
- Posts: 36
- Joined: Thu Jan 02, 2014 6:20 pm
- First Name: Brian
- Last Name: Lannoye
- Company Name: Dealertrack Technologies
- Phone: 801.617.1806
- State / Province: Utah
- Zip / Postal Code: 84095
- Country: United States
- Contact:
Re: Database Driven Auto-Complete
Yes. That is exactly what I am looking for.
-
- Profound User
- Posts: 36
- Joined: Thu Jan 02, 2014 6:20 pm
- First Name: Brian
- Last Name: Lannoye
- Company Name: Dealertrack Technologies
- Phone: 801.617.1806
- State / Province: Utah
- Zip / Postal Code: 84095
- Country: United States
- Contact:
Re: Database Driven Auto-Complete
How do I get the code to display instead of the description?
-
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Database Driven Auto-Complete
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.
-
- Profound User
- Posts: 36
- Joined: Thu Jan 02, 2014 6:20 pm
- First Name: Brian
- Last Name: Lannoye
- Company Name: Dealertrack Technologies
- Phone: 801.617.1806
- State / Province: Utah
- Zip / Postal Code: 84095
- Country: United States
- Contact:
Re: Database Driven Auto-Complete
I used a combo box to get the result I wanted.
Thanks..
Thanks..
Who is online
Users browsing this forum: No registered users and 3 guests