Pull data from access database to InfoPath form

[Melissa]

I'm trying to create a form so that once a user types in their ID, the next
field in the form will polulate with their Name (the database contains
columns for the ID and their name)

I'm sure this is possible I just can't find information on it.. maybe it's
too simple to document..... any help is appreciated.
Thank you!

 

[Swathi]

Hi

Use the following steps.
1. Put a rule on the ID Field.
a. Go to ID field properties.
b. Click on Rules.
c.Click 'Add' and then Click 'Add Action'.
d.Select 'Set a fields value' in 'Action' drop down.
e.Select 'Name field' in 'Field'. then click on the formula button behind
the 'Value' field.
f.On the Insert Formula dialog box, click 'Insert Field or Group'.
g.On the Select a Field or Group dialog box, select the secondary data
source for Name and then click on the 'Filter Data' button.On the Filter Data
dialog box, click 'Add'.
h.On the Specify Filter Conditions dialog box, select ID from the first
drop-down list box, leave the second drop-down list box on is equal to, and
select Select a field or group from the third drop-down list box.
i.On the Select a Field or Group dialog box, choose Main from the Data
source drop-down list box, click on the ID node to select it, and then click
OK.
j.Click OK to close all windows.

2.Finally the expression is like
Set a field's value: Name = @Name[@ID = ID]