Submit & Query different databases

[Vijaya]

Hi,

I am trying to develp an Infopath form for our firm. I should first mention
that I am new to coding and development. I need some assistance here.

I have to query one database but submit data to a different database. I am
able to acheive this goal through two different forms but unable to integrate
the feature into one form. How can I connect to mulitple databases through
Infopath data source connection.

Thank you for your valuable suggestion and time.

 

[wjasonstrutz]

Vijaya,

This should be fairly straightforward. You should design the form from a
data source, which is the database table you want to submit to. Then add a
secondary data source that connects to the table(s) you want to query. You
can have the query occur automatically or create a button to do it for you.

In the design of the form layout, you'll most likely add controls that are
bound to your secondary data source. Then, include rules or code to populate
the datafields of your main data source when your secondary datasource values
change.

As another approach, or if you need to submit to two different databases,
you can have a button that creates an ADO connection and manually performs
the submission. You'll have create the query string manually, and ensure
that the proper rows get updated / inserted however; it's nice that designing
from a data connection handles all this for you.

jason.