Need auto populate field by entering specified value in another field

[LeeRay37746502aydu]

I have a long list of roughly 600 part numbers in an excel form that need to be entered into field 1. Is there a way that typing this can trigger an auto population of field 2 with a corresponding description of part?

[PDF Automation Station]

If you use a dropdown for the part numbers, and enter the corresponding descriptions as the export values, you can populate Field 2 by entering a custom calculation script in field 2:

event.value=this.getField("Field1").value;//Field1 is the dropdown.

I developed a tool that allows you to copy both columns of part numbers and descriptions from Excel and paste them into a window to populate the dropdown.