InfoPath Dev

I am looking for help on what I am doing wrong when publishing a created form to a network location. The form I have created has several connections that retrieve and submit data to an SQL database. I have saved these connections in subfolder as the infopath form. I have saved the form as a normal save...

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 &...