while saving a smartobject creating duplicate row in sql database

+1

Hi,

I am using a Infopath form with somany views, i created a smartobject and which created sql database table.

when i submitted the first view, it created a new row in table with first views data in sql database.

but i capture second view data and submitted, it is saving perfectly but creating a another row and saving into that row.

please help, how can i save second view data in the sameid as first and so on.

actually in submit options, i added new rule but its not working as i looking, creating duplicate rows.

Thanks

ravi k dake

+1

Thanks for the reply.

I didnt understand you.

I already created rule with conditions, as i have 11 views at every step of process.

each view saves a little data of the total infopath template.

my problem is what should i keep to in the second view...

how is set the same Id which is created in 1st view will save second view data in the same row of the sql database(smartbox).

my Id is autonumber with autoincrement by 1.

Please assist.

thanks

Sign up