Jeffrey,

This is expected behavior - when you submit, the database gets updated
with the data that is in your form currently. InfoPath does not perform
a re-insert - so that you could perform an Update operation.

If you want to add several records, insert a repeating table, and bind
it to the repeating group in your data source. A simple way to do this
is to open a Data Source task pane and drag-and-drop your repeating
group onto the form.

Then, when filling out this form, you will have an option to insert
additional rows to that table - which will be almost like editing the
database directly (insert a record - it will appear in the database
after submit).

Good luck!
Alex @ Microsoft

-----Original Message-----
From: Jeffrey [mailto:jeffreyvsmith@gmail.com]
Posted At: Tuesday, May 03, 2005 10:57 AM
Posted To: microsoft.public.infopath
Conversation: submitting to simple database not working correctly
Subject: submitting to simple database not working correctly

I have created a database that has only one table in it just to test
out infopath. There are a couple columns in the database and I made one
the primary key. I create a form in infopath and everything goes well.
I fill out the form and submit and it is successful. Repeat,
successful. etc. But, when I actually go look at the db using Query
analyzer, there is only one line in the table. Everything I type in the
form replaces the existing line in the db. Is this what the submit
button does or ?