Control used to fill multiple fields

[nojyttap]

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.

 

[Clay Fox]

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.

 

[nojyttap]

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."

 

[nojyttap]

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.

 

[cgarrab]

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

 

[nojyttap]

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=4e038a7f3f5b443bbe4db49f86d95fba

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.