Hi,

I have a form and one of the fields is an id code, and each code has it's own description within a sql database, what I am trying to acheieve is that when somebody enters a code into the form field then changes the focus to the next form field I want to trigger a stored procedure to get the description from the database relevant to the code entered and display it on the page.

Getting the information is not a problem but I am not sure how I can trigger the event based on the user selecting the next form field.

Many thanks for any help
Peter

You'll need to use the onChanged event of the input control, and have that fire off a form post. The form will have to post to the same page (called PostBack) so you can then use the value entered to do your look up and populate whatever you need to show the matching description.

If I may offer a better solution:
Seeing as it sounds like you have a fixed set of IDs (with matching descriptions) why not have a dropdown list of the ID, but show the descriptions instead of IDs for a more user-friendly experience?

Peter
------------------------------------------------------
Work smarter, not harder.