Automatically populate customer information from an ID number
Updated: 21 May 2010 | 4 comments
I'm building a form that pulls customer information from our database. We would like to use the AutoCompleteTextBox component for the 5 digit customer ID. When the ID is selected, we would like the Customer name and address fields to be automatically populated. What is the best way to approach this?
discussion Filed Under:
Comments
Re: Automatically populate customer information from an ID numbe
Here's the easiest way to do this:
Here's the harder way to do this:
This second configuration is harder but it makes it so the user doesn't have to click a button.
Hey Thanks Stuper,It
Hey Thanks Stuper,
It definately helped point me in the right direction, but with your first option i'm not getting the right return. In the array return values, i only have options for First and Last. So what i did was created 2 query components. 1 for just the customer ID's (used in the autocomplete) and the 2nd for customer information (including id number) which is used on the exit path look up. When i go into the text boxes for name&address I only see the first and last array values. any ideas?

Jason
www.EdenTechnologies.com
I have had difficulty in the
I have had difficulty in the past getting textboxes to update without leaving the form and coming back.
The reason you're only getting first and last is probably because a text box can only have a single value and not be an array.
If you want to address the array, you'll have to add that info into another selection form. If the ID numbers are unique, then
use first or last, they should always bee the same.
If you want the info to change on option 2, you'll probably have to switch the textboxes to labels and store the values somewhere else.
This make sense?
Thanks Dalceon... I did get
Thanks Dalceon... I did get this working using the first option. i'm going to post a document on how i did it at somepoint this week.
Jason
www.EdenTechnologies.com
Would you like to reply?
Login or Register to post your comment.