Hey guys, I have a annoying problem while
working with InfoPath form, I have a parent table (tbl_Parent {Parent_ID, name, ...}) and child table(tbl_Child{Child_ID,Parent_ID, name,.. }) in the
database, Parent_ID is the primay key of parent table, Child_ID is the primary key for child table, they have one to many relationship. Then I designed a main
infopath form with data fields associated with parent table and a
repeating table in the form with data fields associated with child
table. In the Infopath form, the main connection has two tables associated by Parent_ID.
I can submit data into two tables correctly, but when I
retrieve, make some changes on existing rows and add a new row in the repeating table and resubmit, one of the
existing rows will be re-inserted again, instead of new row. Sounds like you cannot make changes and add new row at the same time, is that right?
By the way, I am using InfoPath 2010, but in order to enable the "submit" button and submit data to database directly, I changed form type from "Web browser form" to "InfoPath 2007 filler form".
Do you guys happen to know the solution for this? Thanks a lot!