[HELP] Dependant DropDownList Arrrrrg!!

[Steve Brassard]

Please be patient.. im new to Infopath.

I am using the northwind database as a datasource. I created a form in
infopath with just 2 dropdownlist bozes. I would like to set the 1st DropDown
list to hold customer names from the customers table in northwind. (I got
that to work)

Then I, based on my selected customer, I would like the 2nd DropDown list to
show me all orders from the Orders table based on that selected customer. (I
cant figure out for the life of me how to do this)

Once this is accomplished above, I want to extend my form with fields to
contain data from that specific order selected from DropDown2 (ex. OrderID,
OrderDate, etc.)

Can someone help me with specific instructions on how to get dropdown2 to
populate based on dropdown1's selection??

Thank you very much!!!

 

[Steve]

Greg, I took a look at the article you suggested
(http://blogs.msdn.com/infopath/archive/2004/03/24/95529.aspx) however, I
still dont understand how to select a customer item and have a query generate
or "filter" the order to show specific orders for that customer in another
dropdown. If you can explain a little further, I would very much appreciate
it! Thanks for the link and its a good reference, I just need a little more
of an understanding I am hoping either you or someone else can provide.