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.