query from two sources

[samuel]

I have built my info path form, and designated a secondary data source table
from a sql server.

In my form, I enter a code that corresponds with a value from the sql server
table.

I would like the info path form to display this field on the form once the
code is entered.

I then will submit the form to update an access table with all the
information from the form.

I'm lost as to how to do this. Please help.

 

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

You need to create a rule on the code field to set the value of the other
field that needs to be filled, and then use a lookup as described in this
article
http://enterprise-solutions.swits.n...election-secondary-data-source&c=infopath2003
starting from step 10.