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/108771.aspxFri, 02 Dec 2016 18:02:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:108771Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/108771.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=108771<p>&nbsp;Hi - sorry I was so slow to see this &amp; hopefully you have figured this out by now - but add a rule to the field bound to your dropdown that sets email to the email value in the secondary data source. Add a filter to make sure you get the right row - where the product line is equal to the selected product line. If you still need help, attach your file to a reply under the Options tab &amp; I can give you a hand.</p>https://www.infopathdev.com:443/forums/thread/108407.aspxWed, 02 Nov 2016 10:07:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:108407Vadim0https://www.infopathdev.com:443/forums/thread/108407.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=108407I have a list on sharepoint which contains 2 columns. For example: column &quot;product line&quot; and column &quot;E-mail&quot; Then created a simple form with drop-down list box which takes values from &quot;product line&quot; column. What I want is to get in another text box the email address associated to selected product line. Please advise how to do it? Thanks !