https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/65931.aspxThu, 14 Apr 2011 13:49:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65931ashoke0https://www.infopathdev.com:443/forums/thread/65931.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=65931<p>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.</p>https://www.infopathdev.com:443/forums/thread/65927.aspxThu, 14 Apr 2011 12:25:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65927Skarn0https://www.infopathdev.com:443/forums/thread/65927.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=65927<p>&nbsp;</p><p>&nbsp;I&#39;m full of suggestions - problem is I don&#39;t always work out if it&#39;s the best solution. But try this.</p><p>Create a secondary datasource xml file with a structure like below.<br /> 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 &#39;Main data-source&#39;.</p><p>&lt;myDatasource&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;record&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;code&gt;25&lt;/code&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;program&gt;AT&lt;/program&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/record&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;record&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;code&gt;26&lt;/code&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;program&gt;BT&lt;/program&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/record&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;record&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;code&gt;27&lt;/code&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;program&gt;CT&lt;/program&gt;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/record&gt;<br /> &lt;/myDatasource&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p>&nbsp;Look at the attached example. The secondary data-source has been included in the template as an included file.https://www.infopathdev.com:443/forums/thread/64929.aspxMon, 07 Mar 2011 18:56:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:64929ashoke0https://www.infopathdev.com:443/forums/thread/64929.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=64929<p>Hello,</p> <p>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 &quot;AT&quot; instead of 25, &quot;ON&quot; instead of 26 and so on.</p> <p>How to do that? Any suggestions?</p> <p>Thanks,</p> <p>Ash</p>