InfoPath Dev

Also. Is there a way to create an automatically incrementing ID in infopath that I could possibly use to avoid duplicates in the drop down?

Sure thing. Its simply a test form so it's very raw. I only have what I'm trying to test in it currently.

Any chance you could attach a copy of your form to a reply under Options?

My SQL guy did show me that we need some type of unique ID for each selection, or it wont go through. The drop down is bound to a primary key field and when I add a unique ID it doesn't work if I do more than one option. Is there another approach I need to take?

Are you submitting blank values in them? Is the drop down bound to the primary key field? Or does the table have an identity column?

Thanks! I've tried this just now and I'm getting the following error "InfoPath cannot submit the form. An error occurred while the form was being submitted. Violation of PRIMARY KEY constraint 'PK_tblDistrList'. Cannot insert duplicate key in object 'dbo.tblDistrList'. The duplicate key value is ( ...

In InfoPath, a multiple selection list box is bound to a repeating field. But with a database bound form, if you had an associated table to store the values from the multi select, you'd have a repeating group for the associated table, and you won't be able to bind a multiple selection list box to that. I can't think of a way to mimic ...

Anyone have any ideas?

This is one of those PITA things in InfoPath Filler. In the Browser, you can switch views and email. In the Filler, you get this icky bug where the email is blank. Instead of using a different view, we use two sections - one that is displayed when the form is filled out and one for emailing. Basically, you can copy your current main view into one ...

Thanks for response. Now I am trying to do this project in other way, but it's always good to know such informations.