<?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>SQL Database Integration</title><link>https://www.infopathdev.com:443/forums/47.aspx</link><description>For questions concerning issues in the integration of SQL and Microsoft InfoPath.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>record versioning with ms access datasource</title><link>https://www.infopathdev.com:443/forums/thread/42521.aspx</link><pubDate>Fri, 05 Jun 2009 10:59:39 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:42521</guid><dc:creator>costin_chivu</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/42521.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=42521</wfw:commentRss><description>&lt;p&gt;Hello All,&lt;/p&gt;
&lt;p&gt;I have an infopath form based on a data source from ms access table. Let&amp;#39;s say that the table contains 10 records with the following columns: firstname, lastname, version. When the user opens the form, he will be able to add records but also to modify existent records. What I am trying to get is the record versioning feature: if the user click submit button, all records (if records was added or some modifications were made against existent records) should be submitted again to the database with field &amp;quot;version&amp;quot; incremented by 1. The database should contain minimum 20 records now, 10 with 1 in version field, 10 or more (added records) with 2 in the same field. &lt;/p&gt;
&lt;p&gt;There is any way to implement this in an infopath form, if possible, but not mandatory, without code?&lt;/p&gt;
&lt;p&gt;Thank you very much, &lt;br /&gt;Costin &lt;/p&gt;</description></item></channel></rss>