Cascading Drop Down Box

[Ana]

I have two dropdown boxes. The first one I want to populate with documents
collection and the second one I want to populate with sub types based on the
first drop down selection.

My drop down boxes are placed in a repeating section and the data sources
are two tables in a database in SQL Server 2005. This tables have one
column/field that allow relationshipby between the two tables, with data
type integer and this field is in one tabl e the primary key.

Can anyone tell me how to do it?

Thank you.
Kind Regards.

 

[Greg Collins]

Try these:
http://www.infopathdev.com/search/SearchResults.aspx?q=Cascading+List&u=2105

 

[Ana]

Hi Greg,
it´s done. I used a queryadapter and then I done a select with the condition
"Where". Here is the example:

vComando = XDocument.DataObjects("MAP_TipoAmbito").QueryAdapter.Command;
vComando = "SELECT [formulario], [Design_TAmbito], [Num_Area] FROM
MAP_TipoAmbito WHERE [Num_Doc] = " +
XDocument.DOM.selectSingleNode("/my:meusCampos/my:Entidade/myrocedimentos/my:Tipo_Doc_Proc").text
+ "and [Num_Area]= " +
XDocument.DOM.selectSingleNode("/my:meusCampos/my:Entidade/myrocedimentos/my:Àrea_Proc").text;

XDocument.DataObjects("MAP_TipoAmbito").QueryAdapter.Command = vComando;
XDocument.DataObjects("MAP_TipoAmbito").Query();

Then I used filters, as you told me, for grouping the data.

Thanks Greg.

 

[Greg Collins]

Great! Glad you got it working!