Background:  This is a status report form requiring history week to week.

I have the repeating table connected to a SQL data connection.  When the
form opens I use this connection to populate this repeating table with the
previous week's milestones (always multiple), is this case 3 rows.   Next, I
need to make changes to the 3 milestones and add a fourth.  Before the user
submits to DB they are required to pick a week ending date.  I use this date
to update the datestamp on the records I'm about to submit.  So what I would
expect is 4 new rows in SQL table with the new datestamp, instead I'm getting
1 new row (milestone 4) and 3 updated rows (milestones 1-3) all with the new
datestamp.  It seems Infopath can't treat rows 1-3 as new, so it updates the
existing rows.  So the big question is how do you maintain a history with
Infopath in a repeating table?