Trying to do something that seems like it should be really simple, but I'm new to VB
(All my development has been asp). I have a form with 4 text boxes: Quantity, Sku, Description, Week, Year.
The user enters the quantity, then the sku. As soon as they leave the sku field, I want to look up the description from a table in the database and place it in the Description field, they then enter the week and year, and upon clicking a button, everything is added to a different table in the database.
It seems like it should be an easy thing to fire a stored procedure once the focus goes on the description box,(taking a parameter from the sku field and looking up the description) and throwing the result into the description textbox, but I can't figure out how to do it yet. I'm sure I'll figure it out, but it's really frustrating to find my way around in this new environment.