2nd drop down data using 1st as restraint

[stc7outlaw]

I'm going to use repeating sections.

This i what I have. I have


APA Number | Task | Price
10 |repair | $5.50
10 |installation | 10.10
10 |clean | 7.15
20 |break | 6.06
20 |mash | 11.75
20 |bash | 4.01
30 |laugh | 2.99
30 |sleep | 1.99
30 |fly | 15.99

I want to have a first drop down that says APA Number and I want to select from 10, 20, or 30. When I select from one of these I get ie(10) repair, installation, clean, in the next drop down, and hold the value of the set price for the task.
(of course for simplicity sake, I just made these things up, but this is exactly what I want to do.

I have exported from an access table to an xml file. I don't know how to get this working. I know it has to do with a filter and a pattern to recognize the APA number. I just have no clue how to do it. I'd pay you if I could for the answer, but I don't have money.
Thank you for your time and effort.
Steve C.

 

[stc7outlaw]

I got the non-repeating Cascading drop down list boxes to work, but I want to get repeating drop downs. Is there a way, similar to this to get it to work without screwing all of the values up, like it did when I tried to use it when repeating?
Thanks

 

[David Fries [MSFT]]

A custom blog post, just for you:
http://blogs.msdn.com/davfries/archive/2004/07/29/200559.aspx

Also, looks like Greg has solved this one as well, in his aptly named
DevNugget:
"Cascading Drop-down List Boxes in a Repeating Table (Using XSL Variable),
v1.0"

Thanks,
Dave

--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
--

I got the non-repeating Cascading drop down list boxes to work, but I want

to get repeating drop downs. Is there a way, similar to this to get it to
work without screwing all of the values up, like it did when I tried to use
it when repeating?

Thanks

Take a look at the InfoPathDev.com Dev Nugget titled, "Creating Non-Repeating Cascading Drop-Down List Boxes"

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



I'm going to use repeating sections.

This i what I have. I have


APA Number | Task | Price
10 |repair | $5.50
10 |installation | 10.10
10 |clean | 7.15
20 |break | 6.06
20 |mash | 11.75
20 |bash | 4.01
30 |laugh | 2.99
30 |sleep | 1.99
30 |fly | 15.99

I want to have a first drop down that says APA Number and I want to

select from 10, 20, or 30. When I select from one of these I get ie(10)
repair, installation, clean, in the next drop down, and hold the value of
the set price for the task.get this working. I know it has to do with a filter and a pattern to
recognize the APA number. I just have no clue how to do it. I'd pay you if I
could for the answer, but I don't have money.

 

[stc7outlaw]

Dave,
When I went throught this and when I got to the xsl modification, the form seems a little different, and when I tried to make the changes all I got were errors. I'm using SP1 and I think this is a V1 tutorial. I don't think it works with sP1. I've been having so many problems.
ALL I WANT IS A REPEATING TABLE USING MULTIPLE DROP DOWNS w/ FILTERED DATA!!!! Bah. These damn voices in my head.
Thanks,
Steve

A custom blog post, just for you:
http://blogs.msdn.com/davfries/archive/2004/07/29/200559.aspx

Also, looks like Greg has solved this one as well, in his aptly named
DevNugget:
"Cascading Drop-down List Boxes in a Repeating Table (Using XSL Variable),
v1.0"

Thanks,
Dave

--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
--

I got the non-repeating Cascading drop down list boxes to work, but I want

to get repeating drop downs. Is there a way, similar to this to get it to
work without screwing all of the values up, like it did when I tried to use
it when repeating?

Thanks

Take a look at the InfoPathDev.com Dev Nugget titled, "Creating Non-Repeating Cascading Drop-Down List Boxes"

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



I'm going to use repeating sections.

This i what I have. I have


APA Number | Task | Price
10 |repair | $5.50
10 |installation | 10.10
10 |clean | 7.15
20 |break | 6.06
20 |mash | 11.75
20 |bash | 4.01
30 |laugh | 2.99
30 |sleep | 1.99
30 |fly | 15.99

I want to have a first drop down that says APA Number and I want to

select from 10, 20, or 30. When I select from one of these I get ie(10)
repair, installation, clean, in the next drop down, and hold the value of
the set price for the task.get this working. I know it has to do with a filter and a pattern to
recognize the APA number. I just have no clue how to do it. I'd pay you if I
could for the answer, but I don't have money.