https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/45422.aspxWed, 05 Aug 2009 03:11:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:45422Jimmy0https://www.infopathdev.com:443/forums/thread/45422.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=45422<p>Could you please clarify what you mean by &quot;go to the last record?&quot;</p>https://www.infopathdev.com:443/forums/thread/45408.aspxTue, 04 Aug 2009 17:44:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:45408Lisa Choi0https://www.infopathdev.com:443/forums/thread/45408.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=45408<p>Hello,</p> <p>&nbsp;I created an InfoPath form that will connect to a sql database and be uploaded to SharePoint via web service.&nbsp; How do I write a formula/rule so that users can go to the last record of that form?&nbsp; I have the field pointing to the qryfield but can&#39;t figure out how to write the formula.&nbsp; I thought if I&nbsp;set the condition&nbsp;&quot; If SpNum is blank&quot; then I could create a rule around that.&nbsp; Is that not the correct path to go?</p> <p>Lisa</p>