return 2 values in drop down

[stc7outlaw]

The following is modified for simplicity but i'd like to achieve the same outcome:
I have a drop down menu. The display is a column of a database (Last_Name)
I have 2 other columns that i'd like to fill text boxes with from the data in the row of the table. The 2 values I want to set for the drop down box are (First_Name) and (Middle). These 3 columns are exported XML from an Access table:

 

[David Fries [MSFT]]

http://www.infopathdev.com/nuggets/
Look for " Creating Non-Repeating Cascading Drop-Down List Boxes"
and
"Cascading Drop-down List Boxes in a Repeating Table (Using XSL Variable),
v1.0"

also,
http://blogs.msdn.com/davfries/archive/2004/07/29/200559.aspx
Dave

The following is modified for simplicity but i'd like to achieve the same outcome:
I have a drop down menu. The display is a column of a database (Last_Name)
I have 2 other columns that i'd like to fill text boxes with from the data

in the row of the table. The 2 values I want to set for the drop down box
are (First_Name) and (Middle). These 3 columns are exported XML from an
Access table:

--------------------------------------------
|Last_Name | First_Name | Middle |
--------------------------------------------
|Brown | Joe | T |
|HAwk | Ace | A |
|Hull |John | J |
|Mack |Steve |H |

and fill 2 separate text boxes to the right of the drop down. This also
must be in a **repeating section** so I can do a few names at a time. How
can I go about doing such a task?

This is the simplified version, but I need these values to fill 2 separate

text boxes but I'm doing some calculations. I think by displaying it this
way it makes it easier. Can someone help me? Is it Jscript? or something
else.

 

[stc7outlaw]

I can't get the blog to work. I set everything up but when I went to edit the view1, the format was slightly different and I all I got were errors when I tried to edit it. Is this for V1 or SP1? I have sp1. I also am not using Cascading drop downs. I'm just using 1 drop down and I want to fill in 2 text boxes with that one drop down. Maybe you can help me.
Thank you