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/78929.aspxThu, 24 May 2012 17:53:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78929Anson Hidajat0https://www.infopathdev.com:443/forums/thread/78929.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=78929To answer #3, create another data connection (DC) to the same list.&nbsp; When the dropdown value changes, create a rule that set&nbsp;the queryField on the new DC of the NAME to that dropdown value.&nbsp; Then run the query against that DC.&nbsp; It should return the Phone&nbsp;Number that matches that entry which you can write back to your form via rules.https://www.infopathdev.com:443/forums/thread/78831.aspxMon, 21 May 2012 21:02:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:78831mackie0https://www.infopathdev.com:443/forums/thread/78831.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=78831<p>Hi All,</p><p>I have a couple questions, hopefully someone can help.</p><ol><li>Any way to send my infopath form in a DRM&#39;d email?&nbsp; If not, could I have Infopath submit my email form to a DRAFT in outlook so the user could set DRM prior to emailing?</li><li>Any easy way, or does someone have the&nbsp;code to change the &quot;From&quot; email address when sending my form? (might be the same as #1)</li><li>I have a list&nbsp;with 2 columns in Sharepoint and I&#39;m using it as a data connection in my form, let&#39;s say the column names are&nbsp;NAME and Phone Number.&nbsp; When a person selects NAME from a drop down list, I want the value for my phone number dropdown list (or a calculated value box) to display their phone number that matches.&nbsp; How can i do that?</li></ol><p>Thanks in advance,</p><p>Mackie</p>