InfoPath Dev

I can definitely test it out. Thank you so much for confirming this with me. I'll keep you posted on if this solves this on monday.

We do have that. Do I need to tie the drop down control to that instead of the Name field?

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.

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?

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 ( ...

Anyone have any ideas?

I currently have a filler form with query and submit features to a SQL Server database (directly. not with a web service). I'm noticing when I'm dragging my SQL tables onto my form, regardless of how the table is set up, the control is a text box. I've gotten into the habit of changing them, but a lot of my original form design uses ...