Auto Increment server side update

[Simon]

I've created a form in InfoPath which submits data into an SQLServer database
table and I want the ID field to automatically increase, according to the
value already in the database + 1.

 

[Scott L. Heim [MSFT]]

Hi Simon,

What you could do is add either an "Expression Box" or a new "Text Box" to
your form and simply have a formula that points to your current "ID" field
and adds 1 to it.

Best regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.