InfoPath Dev

Hello,

In one of my forms, I have an expression box that will take value from a node called program. The expression box is taking value e.g. 25, 26, 27 etc. as entered in program field (drop down). I want the expression box to view "AT" instead of 25, "ON" instead of 26 and so on.

How to do that? Any suggestions?

Thanks,

Ash

 I'm full of suggestions - problem is I don't always work out if it's the best solution. But try this.

Create a secondary datasource xml file with a structure like below.
Then for the expression box value, select the program field/node from record repeating group/node in the myDatasource secondary connection with a filter where code field/node = value of the field/node which the user has filled in called my:program from the 'Main data-source'.

<myDatasource>
       <record>
               <code>25</code>
               <program>AT</program>
       </record>
       <record>
               <code>26</code>
               <program>BT</program>
       </record>
       <record>
               <code>27</code>
               <program>CT</program>
       </record>
</myDatasource>             

Hello Skarn, Thanks for taking time to make a sample for me. Much appreciated. In fact, I have done it by adding rules in nodes. Thanks again.