InfoPath Dev

I am creating a form that is connected to a SQL DB. The form is conected to a couple different tables. When I hit submitt it returns the error "Field or group: TargetMarketID Error: Only integers allowed"

This field is the PK, looking at functioning forms the only difference I can find is that the properties on my PK are set at "int" and the functioning forms properties PK are set at "optional_int." Also my PK is set to require a value and will not let me edit the field. Any help would be appreciated. Thank You!

I had the same problem many times, I had to troubleshoot the issue. When I experience the problem, the data type for the primary key was wrong(should be int) or the permissions to submit to the database has to be true for update, insert, view. Good Luck.

The PK is set to "int" and permissions are set correctly. Any other suggestions would be appreciated. Thank You!

Try this......

Make sure Primary id int(data type) 4(Length)

At the bottom of the bottom the Columns should be set to.....

Precision = 10
Scale = 0
Idenity = Yes
Identity seed = 1
Idenitity Increment = 1
ISRowGuid = No