InfoPath 2003 Formula Question

[Tanya216]

I have a question, I am working on a template that was previously in Excel,
and I've converted it into a InfoPath form. Previously in excel, I had a
field that once selected would populate related data in other fields. For
example, if someone selected dept 123, it would populate another field with
the VP for that dept, and the Division. I am trying to get the same
functionality in InfoPath. Can someone help me accomplish this? Here is
what I have. Below are the fields I need assistance with.

Dept.: (drop-down list) pulling form access db
Dept. Leader:
Home Portfolio:
Portfolio VP:

So I want when they select a dept #, that the dept would recognize the
association below and populate the fields as shown below:
Dept Leader: John Doe
Home Portfolio: Retail
Portfolio VP: Jill Doe

Is this possible? Please help. In excel I used this formula:
=IF(ISERROR(VLOOKUP($E$27,$N$3:$R$63,3,FALSE)),"
",(VLOOKUP($E$27,$N$3:$R$63,3,FALSE))) The range shown represents the
associations between the various field info.

Thanks

 

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

You can use the technique described in this article:
http://www.bizsupportonline.net/inf...-dropdown-selection-secondary-data-source.htm

 

[Rajitha]

Hi,
Please verify the below link.
In this link they have used XML as secondary Datasource. You can select
values from your secondry datasource which is access db.
http://www.infopathdev.com/blogs/ma...e-Fields-from-a-Drop_2D00_Down-Selection.aspx