<?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>InfoPath 2010</title><link>https://www.infopathdev.com:443/forums/142.aspx</link><description>Are you exploring new features coming up in 2010? Share information and ask questions here!</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Infopath Multiple view data insert issues</title><link>https://www.infopathdev.com:443/forums/thread/119824.aspx</link><pubDate>Fri, 14 Sep 2018 23:16:31 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:119824</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/119824.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&amp;PostID=119824</wfw:commentRss><description>It has been a long time since I&amp;#39;ve worked with a database bound form. But I&amp;#39;d guess that the ID field in the data fields is still populated with the primary key - could that be it?</description></item><item><title>Infopath Multiple view data insert issues</title><link>https://www.infopathdev.com:443/forums/thread/119812.aspx</link><pubDate>Fri, 14 Sep 2018 04:17:05 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:119812</guid><dc:creator>Phani404</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/119812.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&amp;PostID=119812</wfw:commentRss><description>I am working with 2 views 1) search and update with Row ID column 2) Insert new record.

Submit option:Submit to Database using custom code and rules. (Primary Key: Row_Id , Identity column)

Submit button is updating previous search record instead of inserting new record into database when I search &amp;amp; do something in 1st view and navigate to Insert view.

e.g. Search row id : 100 and do some update in 1st view, then navigate to Insert view or 2nd view.

then click on Submit. It actually updating record for Row_id 100 instead of inserting records with 101 row_id

If I directly do insert without searching anything, new record is inserting.

I am submitting form using custom code under button click.

 DataConnection Insconn = DataConnections[&amp;quot;submit&amp;quot;];
 Insconn.Execute();

Is anyone help me how to achieve this?

I also tried using 1 view for Search and Insert,  same issue.

Thanks</description></item></channel></rss>