submitting to sql database

[saelbeth]

I know that you can submit to a database if you design a form from the
database initially, but is there a way that you can retrieve and submit
to more than one database in a single form? That is, have one view with
a database you can retrieve and submit to, and have a different
database in a different view?

 

[S.Y.M. Wong-A-Ton]

You can add several "receive data connections" to retrieve data from the
databases and display them in the views. To submit data back to the
databases, you'll have to use web services.

 

[Anthony A.]

Thanks - I've ended up resorting to that, although I'm having some
problems with it. On the form, there's a repeating section with
controls that the user can fill out. When they press a button, I want
the data from each of the repeating sections to get sent to the web
service. I have it set up as a submit button, but it only sends the
first section of information. Do you know how to fix this?

 

[Anthony A.]

Nevermind, I figured out how to do it using code.
~Anthony