Infopath generating two inserts

[Erin]

I am relatively new to Infopath but love the capability to create forms to
insert/update data in SQL Server easily. I have a hierachical structure
(Customer --> Engagement --> EngagementEmployee) that I am using. When I
enter a new customer, the form displays an empty form so I can enter
engagement and engagement employee information, as it should. When I fill
out the entire form and press Submit, it inserts the customer correctly, then
inserts an empty Engagement record immediately followed by a populated
Engagement record. This is what I see in SQL Profiler. I end up with two
engagement records (1 empty) when I should only have 1.

I have no idea what to even look for when diagnosing this. Can someone at
least tell me what I should be looking for?

Thanks!
Erin

 

[Eamon]

Hi Erin,
Having the same problem with spurious inserts....
Did you manage to solve the issue?

TIA
Eamon

 

[Erin]

Hi Eamon,

No, I haven't. It's not a highly active database so I'm just occasionally
cleaning up the empty records. Would love a better solution.

Erin