Populate fields based on selection in drop-down

[CycleFitness]

_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

 

[Chucky]

I have the same issue. I want to autopopulate simple text fields from
information stored in an Access DB but only when a user selects an item from
a drop down box which is on the same form and connected to the same Access
DB. This is likely very easy to do but I have yet to get it to work.