InfoPath with SQL Server

[Moojjoo]

I have developed a quick DB with two tables both with ID Primary Keys with
Identity enabled.

I then opened InfoPath to design the form.

When I try to submit I get an error -

"InfoPath cannot submit the form because it contains validation errors.
Errors are marked with either a red asterisk (required fields) or a red,
dashed border (invalid values)"

Ummm no duh, but why isn't InfoPath smart enough to know this is an
identity field. How do I develop the form to work?

 

[Gavin McKay]

Hello,

I wasn't able to get this error. I added a test table with two fields:

idcol (PK, identify)
valuecol (char[10])

and added both fields to the "Drag data fields here" section. I then
previewed the form and filled in text in the valuecol, leaving the idcol
blank. When I submitted, it worked and populated the idcol.

I note that the instructions say "table must have a Primary Key defined in
order to submit" but by the sounds of it you have done that. Have you tried
deleting the id column from the data area and submitting?

HTH

Gavin.