[thelist] User form input question

[Brian Delaney]

Ok, this is another user request that I am not sure how to pull off:

There are about 200 agencies. The agency table contains an ID, name and 
code.

During data entry the clerks know the agency code before the name.

The would like to be able to enter the code and have the next field auto 
populate with name.

I have a record set with the Agency info that it retrieved when the page 
first  loads.

I am using asp, javascript, html on IIS with sql 2000 backend.

Thanks,
BD

*
*
*
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or priveleged information.  Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.