<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Data Connections</title><link>https://www.infopathdev.com:443/forums/44.aspx</link><description> </description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Serial Number update code snippet</title><link>https://www.infopathdev.com:443/forums/thread/23125.aspx</link><pubDate>Tue, 18 Sep 2007 14:27:32 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:23125</guid><dc:creator>Clay Fox</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/23125.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&amp;PostID=23125</wfw:commentRss><description>&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Hi Scott.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;To do this does not require code but it does require Web Services, which give you the ability to both query and submit to multiple tables. Check out the Database Accelerator which gives you a whole suite of web services to use. &lt;a href="http://www.infopathdev.com/files/folders/dbxldownload/entry22386.aspx" target="_blank"&gt;Qdabra Database Accelerator Suite Version 2.1.2815 - Developer&lt;/a&gt;&lt;/p&gt;&amp;nbsp;With this you can increment your master number in the form load and then use it in your additional table entry.&amp;nbsp; If you need help or a demo just let me know.</description></item><item><title>Serial Number update code snippet</title><link>https://www.infopathdev.com:443/forums/thread/23112.aspx</link><pubDate>Mon, 17 Sep 2007 23:30:41 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:23112</guid><dc:creator>haighsd</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/23112.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&amp;PostID=23112</wfw:commentRss><description>&lt;p&gt;Being a NON coder,&amp;nbsp;I was wondering if someone could point me to a source of common code snippets for use in Infopath Forms..&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; In particular I am looking for a piece of code that I can tie to the &amp;quot;NEW RECORD&amp;quot; button that:&amp;nbsp;&amp;nbsp; &lt;/p&gt;
&lt;p&gt;1) Opens a SQL DB file data source, reads a master number&lt;/p&gt;
&lt;p&gt;2) Increments the master number by 1 and writes it back, closes the file.&lt;/p&gt;
&lt;p&gt;3) places the number read into a field on the form to be submitted into the main datasource on a submit&lt;/p&gt;
&lt;p&gt;&amp;nbsp;any help on this would be greatly apreciated...&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Scott haigh&lt;/p&gt;</description></item></channel></rss>