How do I make a displayed value dependent on another selection?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

delphinium - 27 Dec 2007 20:45 GMT

I'm working in InfoPath 2007. I have an xml data source file I'm associating
my controls with to pull data. The user selects an ID number from a drop
down list and on the other side of the form the associated "owner" value
should display. How do you direct either the action of selecting the ID
number from the list or clicking a submit button once an ID number is
selected to go to the data source and find the associated "owner" value from
the "owner attribute?

Reply to this Message

S.Y.M. Wong-A-Ton - 31 Dec 2007 04:09 GMT

Please try to rephrase your question. I think many in the group - including
myself - are having difficulty understanding what you are trying to
accomplish.
---
S.Y.M. Wong-A-Ton

> I'm working in InfoPath 2007. I have an xml data source file I'm associating
> my controls with to pull data. The user selects an ID number from a drop
[quoted text clipped - 3 lines]
> selected to go to the data source and find the associated "owner" value from
> the "owner attribute?

Reply to this Message

delphinium - 31 Dec 2007 15:32 GMT

OK. I am trying to accomplish a field in InfoPath displaying associated data
to the input of another field. In other words, I'm looking for some type of
LookUp function. For example:

1. In Field A, user selects from a dropdown list item #2 which reads "cow"
in the list.
2. The xml data source looks something like this

<topic id="donkey" revisionNumber="4" author="blaine"></topic>
<topic id="cow" revisionNumber="0" author="sally"></topic>

How do I set up a Field B that looks up and displays the associated author
value "sally"?

Thanks!

> Please try to rephrase your question. I think many in the group - including
> myself - are having difficulty understanding what you are trying to
[quoted text clipped - 9 lines]
> > selected to go to the data source and find the associated "owner" value from
> > the "owner attribute?

Reply to this Message

S.Y.M. Wong-A-Ton - 01 Jan 2008 02:00 GMT

Ah, things are much clearer now. Thanks for that! You have to use rules and
filters. Take a look at this article:
http://enterprise-solutions.swits.net/infopath2003/autofill-fields-dropdown-sele
ction-secondary-data-source.htm
While it uses a database to lookup information, you can apply the same
concept to an XML file.
---
S.Y.M. Wong-A-Ton

> OK. I am trying to accomplish a field in InfoPath displaying associated data
> to the input of another field. In other words, I'm looking for some type of
[quoted text clipped - 25 lines]
> > > selected to go to the data source and find the associated "owner" value from
> > > the "owner attribute?

Reply to this Message