Assign a lookup database value to a Text Input Box Follow
I am pretty new to Data Entry Form and not sure how to do this and here is my setup on data entry form:
Part Number 1<Text Input Box 1> Part Description 1<Text Input Box 2>
Part Number 2<Text Input Box 3> Part Description 2<Text Input Box 2>
So when I enter some string in Part Number 1 it will look this up in our ERP db for the description and assign the description value to Part Description 2. Do the same thing for Part Number 2. I know how to create a VBScript to connect to my ERP db but not sure how to assign the return value into the description text input box.
Please sign in to leave a comment.