https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/92370.aspxTue, 20 Aug 2013 11:00:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92370wilkies0106aw0https://www.infopathdev.com:443/forums/thread/92370.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=92370<p>I&#39;ll assume the secretary details are in AD.</p><p><span class="gmw_"> I&#39;d use a 2nd <span class="gm_ gm_0445cbad-d7c9-b753-a5c4-45184bc3ab4b gm-spell">getuserprofile</span> data connection and something like the following : </span>http://www.infopathdev.com/forums/p/23994/83185.aspx#83185</p>https://www.infopathdev.com:443/forums/thread/92355.aspxMon, 19 Aug 2013 18:26:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92355arkainus0https://www.infopathdev.com:443/forums/thread/92355.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=92355<p>Hi all,</p><p>I have a question and wasn&#39;t sure how best to categorize it, so placed it in general per the heading of the category. I am hoping to get some thoughts on my issue. I have an infopath form (2010) that I am creating for SharePoint. I have four fields set aside for the assignment of the duties this form is set to handle. What I would like to achieve is to have the form set the value of a specific field based on what was chosen in another field. So, for example, I have a field named &quot;Primary&quot; and based on who the user chooses in that field, I would ilke the &quot;Primary Secretary&quot; field to auto-populate with the info of that users secretary. I am not incredibly well versed in InfoPath, but I did figure out I could set up rules for the Primary field to achieve what I wanted. My questions are:&nbsp;</p><p>1. Is that the best method to achieve what I desire? There are 29 different possibilities for the &quot;Primary&quot; field and I wasn&#39;t sure that this is the best way to handle this. Does the evaluation of 29 rules significant impact performance for the end user?</p><p>&nbsp;2. How cumbersome (and what considerations would need to be made) to make a Changed Event code fire everytime&nbsp; one of those fields is changed? I assume that would be speedier? I&#39;ve done macro&#39;s for word docs, some C++, but am far from an expert coder. What requirements need to be met for a form to have code on it in a domain environment? </p><p>&nbsp;3. Is there some solution I am missing here, that doesn&#39;t require custom coding or adding 129 different rules to my form over those four fields? </p><p>Sorry for these noobish questions and I would be greatly appreciative of any and all help that you may be able to provide on this. Thank you in advance! </p>