Assign a lookup database value to a Text Input Box 追蹤

Gia Pham


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.