populating fields using access

[Lou]

HI there. I'm trying to do the following:

-I have a drop-down list that is populated with data from Access. The
database in Access has two fields: "student" and "email". This drop-down
list in InfoPath, then, is populated by the "student" field in Access. So I
select the student, and the bound field in InfoPath is populated with the
information. Next to the "student" field in the form, I want the student's
corresponding email address to be populated, but I can't figure out how to
select the "email" address form from the Access database.

As you can probably tell, I'm certainly no computer guru, but any help will
be most appreciated.

 

[Clay Fox]

Hi Lou.

Typically you would add a rule to your dropdown that set the value of the
email field to email address with a filter that named in the list equalled
name in your dropdown field which they just selected.

You may want to look at an Active Directory web service so you can look up
that information directly without having to maintain your own list of names
and emails.