return 2 values in drop down

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stc7outlaw - 30 Jul 2004 01:11 GMT

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 |

--------------------------------------------
The drop down will reference from the Data source the values of Last_Name, 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.

Reply to this Message

David Fries [MSFT] - 30 Jul 2004 04:47 GMT

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 |
[quoted text clipped - 5 lines]
> --------------------------------------------
> The drop down will reference from the Data source the values of Last_Name, 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.

Reply to this Message

stc7outlaw - 30 Jul 2004 05:27 GMT

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

> http://www.infopathdev.com/nuggets/
> Look for " Creating Non-Repeating Cascading Drop-Down List Boxes"
[quoted text clipped - 31 lines]
> way it makes it easier. Can someone help me? Is it Jscript? or something
> else.

Reply to this Message

Greg Collins [MVP] - 30 Jul 2004 20:01 GMT

It sounds like what you want to do is just populate a couple of fields based on the value of a drop-down list box.

If this is the case, please take a look at the InfoPathDev.com Example title, "Populating Fields After Selection". It should show you how to do what you want -- It's using SQL as a secondary data source, but you can just as easily change it to an XML secondary data source.

Signature

Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com

Reply to this Message

Rate this thread: