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/103293.aspxFri, 17 Jul 2015 15:34:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:103293markos170https://www.infopathdev.com:443/forums/thread/103293.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=103293<p>Hi,<br />In my InfoPath 2010 form I have dropdown field &#39;Project&#39; and another dropdown &#39;Priority&#39;.<br />I want to set default &#39;Priority&#39; value to the same as the last record with that project.<br />example:</p><p>Project | Priority </p><p>a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 20</p><p>a &nbsp; &nbsp; &nbsp; &nbsp; | 30</p><p>b &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; 5</p><p>I create another record, change &#39;Project&#39; value to &quot;a&quot; and the value of Priority suppose to set to 30.</p><p>I&#39;m thinking about creating new datasource with sql query. Then set up new rule when changing &#39;Project&#39; and set &#39;Priority&#39; value.</p><p>Do You think, that there is some other way to achieve it?&nbsp; <br /></p><p>&nbsp;</p>