Query field data from one database and save to a different one?

[Gail]

I have created my form connected to a database, I want to query a field's
data from one access database and then save the information to another.
Basically, I want to post the Salesman name from one database and then save
that name in another database (the one the form is connected to.

 

[Swathi (GGK Tech)]

Hi,
First take two data connections for two data bases.
Get the data from the first data base and set that value in a form field.
Then use the following link to submit the data to another data base.
http://office.microsoft.com/en-us/infopath/HA102117541033.aspx