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.