I have a SharePoint 2010 list with the NewForm and EditForm default forms. We are in an extraordinarily strict environment where we can't use workflows, InfoPath, or anything else besides out of the box (OOTB) SharePoint functionality.
I want to create a second list to serve as a lookup with two columns, representing a one-to-one relationship. These are serial numbers to products. Each serial number only identifies one particular product.
On the main list, the first field will be for the user to enter the serial number. We use column validation to ensure it is entered correctly.
If the users enters a legitimate serial number, we want the list to autofill the name of the product from the second lookup list in a text field several lines below. If the serial number isn't recognized, nothing happens and the user is expected to enter the name of the product on their own. There are rare occasions where the user may enter a serial number for a product not in our database, so we aren't going to strictly validate this.
Can someone point me to a good link on how to do this?