https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/72148.aspxThu, 17 Nov 2011 15:55:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:72148Infiltraitor0https://www.infopathdev.com:443/forums/thread/72148.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=72148<p>Hello,&nbsp;</p><p>This is my first post here and fairly new to Infopath, please excuse if this question has been asked before. </p><p>&nbsp;I have a field that is linked to a team id and what I;d like to do (if possible) is to create a function in infopath which either queries the database for a current count of records or pulls the number from a query within the access database by&nbsp; team id and then uses that count number and increments it by one when submitting a new record in the form to generate a specific record id.</p><p>&nbsp;</p><p>Any suggestions would be greatly appreciated.&nbsp; <br /></p><p>&nbsp;<br /></p>