https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/38647.aspxThu, 19 Feb 2009 21:15:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:38647Tracie0https://www.infopathdev.com:443/forums/thread/38647.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=38647<p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><span style="FONT-SIZE:10pt;FONT-FAMILY:Arial;">I am working in SharePoint and InfoPath 2003 and would like to&nbsp;assign each form an Auto Number.&nbsp; </span><span style="FONT-SIZE:10pt;FONT-FAMILY:Arial;">I have created a data connection named &quot;Retrieve ID&quot; to place the SharePoint ID number into an InfoPath form.&nbsp; </span><span style="FONT-SIZE:10pt;FONT-FAMILY:Arial;">The rule is to run the a query to pull the ID number and then set the field &quot;Form ID&quot; with the formula &quot;max (@ID) + 1&quot;.<span style="mso-spacerun:yes;">&nbsp; </span>This ID appears when I go from Design Mode to Preview.<span style="mso-spacerun:yes;">&nbsp; </span>However, when I go from the Home Page to the library, the ID field is blank.<span style="mso-spacerun:yes;">&nbsp; </span>What can I do to ensure that the ID pulls every time the form is opened?</span></p>