using one field to populate another using xml

[theeerike]

im making a simple order form and everything else works fine on it but i want to add this feature. i want to have an user entred item number automticlly populate the decription field. it seems simple enough but i cant make this work. i have an xml file with all the part numbers and descreiptions.

Part Number                  Description    

    1130              TYPE B BEAD CHAIN CPLG

     ^user                ^auto filled

heres a sample of the xml.

<products xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<item>

<PARTNUMBER>113</PARTNUMBER>

<DESCRIPTION>5/16X3-1/2 BR CLOSET BOLT</DESCRIPTION>

</item>

<item>

<PARTNUMBER>1130</PARTNUMBER>

<DESCRIPTION>TYPE B BEAD CHAIN CPLG</DESCRIPTION>

</item>

</products>

any help is much appreciated!!

[Former Community Member]

I created a sample for you ....the code is on the exit event of the DDlist. The data must be loaded into the form before it will work. You can do that through preview, or import it after you open the form.

Paul