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/46410.aspxSat, 29 Aug 2009 10:21:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:46410Qazi Anis0https://www.infopathdev.com:443/forums/thread/46410.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=46410<p>you can set the value of a field to another field not the name of a field to another field. Changing the field name amounts to changing the schema of the form, which i dont think is possible</p>https://www.infopathdev.com:443/forums/thread/44179.aspxSat, 11 Jul 2009 19:17:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:44179j0nxy0https://www.infopathdev.com:443/forums/thread/44179.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=44179<p>I have a form that needs to do some calculations on one of 20 or so columns.&nbsp; It determines what column it needs each time by comparing a date field on the form (then there needs to be&nbsp;20 conditional statements to&nbsp;find it ie: date &gt; 1-1-09 or &lt; 1-30-09)&nbsp;.&nbsp;&nbsp;There are&nbsp;several places on the form where&nbsp;I need to&nbsp;reference this column.&nbsp;&nbsp;With out looking up the column each time and doing the 20 conditions, is there a way to look up this column once and set that column name to a variable of some sort and be able able to use that in formulas on the form?</p>