_I have Matt Faus' article titled "Automatically Populate Fields from a
Drop-Down Selection," which describes how to use an XML file as a secondary
data source to looking up client information.

In my case, I'm using a connection to an Access database which is using a
query.  

I have a key field called dbPlanID in the database.  I have a drop-down list
in the InfoPath form named formPlanID.  The properties of the formPlanID
drop-down look like this:

Data Connection: qry_MakeSecurityGroup
Entries: /dfs:myFields/dfs:dataFields/d:qry_MakeSecurityGroup
Value: @PlanID
Display Name: @PlanID

This key field should then trigger populating one other field on the form:
frmName (from dbName)

In the Rules for the formPlanID drop-down I've added (based on Matt's
instructions):

Rule 1 - Set Name
Set a Field's Value = frmName = @dbName[dbPlanID = current()]

My drop-down list properly displays a list of PlanIDs, but when I select
one, the frmName does not populate.

I don't know much about XPath, so appreciate any help anyone can offer.

Deb