Control used to fill multiple fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nojyttap - 29 Feb 2008 21:14 GMT

I have an XML document (Data1) that has a repeating table with three columns.
In another form I would like a dropdown listbox to let me choose from the
first column of Data 1 and then subsequently fill in the other two pieces of
data in two text boxes below that dropdown. Only one line from Data1 needs to
be choosen. I cannot reference a data base at this time so Data1 needs to be
present on the user's computer.

Reply to this Message

Clay Fox - 29 Feb 2008 21:43 GMT

You would create a data conneciton to the xml file and choose to have it
included with the template.

Then setup a dropdown which is bound to the first field you want to set and
uses the first field of the xml data as it source so that it is displayed in
the dropdown.
Then at a rule to the drop down that has two setfield actions which transfer
the xml field values to the form fields. You will need to use a filter on
both that says use the records which field1 = the value in the dropdown so
you get the right row data.

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> I have an XML document (Data1) that has a repeating table with three columns.
> In another form I would like a dropdown listbox to let me choose from the
> first column of Data 1 and then subsequently fill in the other two pieces of
> data in two text boxes below that dropdown. Only one line from Data1 needs to
> be choosen. I cannot reference a data base at this time so Data1 needs to be
> present on the user's computer.

Reply to this Message

nojyttap - 29 Feb 2008 21:58 GMT

Thanks for the quick response!

I'm not sure exactly how to do this part;

"Then at a rule to the drop down that has two setfield actions which transfer
the xml field values to the form fields. You will need to use a filter on
both that says use the records which field1 = the value in the dropdown so
you get the right row data."

> You would create a data conneciton to the xml file and choose to have it
> included with the template.
[quoted text clipped - 13 lines]
> > be choosen. I cannot reference a data base at this time so Data1 needs to be
> > present on the user's computer.

Reply to this Message

nojyttap - 03 Mar 2008 21:42 GMT

Well, I've messed around for a couple of days with no luck. I have the first
part of your suggestion but I loose ya where you start about the rule on the
dropdown...I just can't figure out how to set that up.

More help would be much appreciated.

Reply to this Message

cgarrab - 04 Mar 2008 19:16 GMT

I'm actually interested in this solution as well using .xml. I have created
the .xml lookup in the first list box and can pull back the information just
fine. I run into trouble trying to pull back the related data, i.e., I have
a unique identifier. Once selected, I want another field to pull back the
data related to that unique ID.

Help

> Well, I've messed around for a couple of days with no luck. I have the first
> part of your suggestion but I loose ya where you start about the rule on the
[quoted text clipped - 19 lines]
> > > be choosen. I cannot reference a data base at this time so Data1 needs to be
> > > present on the user's computer.

Reply to this Message

nojyttap - 04 Mar 2008 19:40 GMT

Well I've gotten close to what I want. I found some info about the cascading
list at
http://archive.infopathdev.com/howto/tutorials/default.aspx?i=4e038a7f3f5b443bbe
4db49f86d95fba

What I have now is a drop down list box that lets me select the first column
and then enters the second and third column data into two list boxes.

The only thing is I have to leave two lines of space in the list box becasue
there is an automatic blank line at the top. If any one knows how to get rid
of that top line please let me know.

I had to use either the drop down or the list box because they were the only
ones that let you use "Look Up Values In A Data Connection" and then filter
that.

> I'm actually interested in this solution as well using .xml. I have created
> the .xml lookup in the first list box and can pull back the information just
[quoted text clipped - 27 lines]
> > > > be choosen. I cannot reference a data base at this time so Data1 needs to be
> > > > present on the user's computer.

Reply to this Message

Rate this thread: