-
Work it :) , thank you !!!
-
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.
-
What happens if you try using the "new record" feature built into IP? That is, add a button that has the action of "new record"?
-
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 ...
-
I'm a little bit confused, I'm afraid. What are you trying to do? Create a new record by modifying the key of an existing record?
-
I have a form that I wrote in IP 2007. It used filters and I wanted to make it web based so I upgraded to Office 2010. Now when I try to publish the form as a web based form I get the message "The form cannot be converted because it was designed for a later version of Infopath Forms Services". In the design checker I get "Invalid ...
-
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 ...
-
i'm afraid you will need to change your data connections to point on your LIVE server. Infopath and sharepoint cannot have lookups to lists that are not in the same server.
-
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 ...
-
If you walk through your main data connection again, there will be a message in the last window of the wizard as to why you can't enable submit. It may be your table(s) have a data type that InfoPath doesn't care for, or no primary key ... So under Data Connections, select your main data connection and select Modify, and walk through the ...