InfoPath Dev

I just changed the button from "Submit" to "New Record". there is noplace to hookup a db connection. I hit the button and it does nothing, does not complain, does nto say anything. And does not put the record into the DB.

I have a table with 3 fields, every record in the DB should be unique, thus the 3 part primary key. I want the InfoPath form to allow the user to enter new records into the table. So they type in the 3 fields and hit the submit button. If the record already exists it should say so and not put the duplicate record into the DB. If the record ...

Hi Hilary, Looks like there are 2 ways it should work. they way you list above and there is also an option under "Send for data to a single destination" of Database. but neither of the 2 methods really work. no mater what I type into my 3 fields that are part of my 3 part primary key InfoPath thinks the record already exists even ...

Ok I am getting somewhere. I added a primary key of 3 fields. I was able to enable submit. when I put a record in with the exact 3 fields that already exist in the db it works as expected - it does not let me put in a dup record. But when I change the last of the 3 fields to be different - so now the primary 3 part key is unique - it still tells ...

The form is designed off the database – at least it reads the data from the DB and displays the data on the form, but I cannot get it to submit to the DB. How do I do that?

Hi Hilary, in you second set of steps, step 10 says: Make sure the data connection is your main data connection. How do I do that? how do I set up a main data connection to write data to my SQL Server 2008 DB? The choices I am given when I try to set one up in the data connection wizard under "How do you want to submit your data?" ...