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 & 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["submit"];
Insconn.Execute();
Is anyone help me how to achieve this?
I also tried using 1 view for Search and Insert, same issue.
Thanks