SQL Server submit error

[Jim Hutchinson]

I am trying to submit changes from a remote desktop to a SQL Server. I can
query the DB fine, but when I try and add a button to submit changes, there
is no option for database in the "Submitting Forms" dialog box?

Anyone else have this problem?

 

[Lip Joo]

Hi,

You would require to design a new form using "Data Connection" then only
you'll be able to submit your forms back to the database.
Else you will required to build a web service to submit your form to the
database.

Regards,
Lip Joo

 

[Jim Hutchinson]

I actually figured out what was wrong. I did not have a primary key set in
the database. DB 101.

Thanks