How to filter data from a secondary data source

[Cyril]

I have a sharepoint site with a form librairy.
I added my sharepoint list to the the secondary data source, then I dragged
and dropped a field on may form, which led to the creation of an extensible
section.

I am willing to FILTER the extensible section using the data contained in
another listbox

HOw to do it? is it possible? I can't figure a way ?

Cyril

 

[Ben]

I tried to do this by
setting up secondary data source
inserting a text box 1 (active or inactive)
inserting a repeating section containing a text box 2 (display project name)
Set the default value to display values from the secondary data source if
the value of text box 1 matches the value of a second field (active or
inactive) in the data source.

This resulted in only one entry in the data source although there were
multiple projects that matched the criteria.

Anyone have a suggestion that works?

 

[Greg]

Have you tried setting a filter on the secondary data
source? In the properties of the drop down box that youve
linked to the secondary data source, click the select
XPath button next to the entries field and then Filter
Data...

You can then add a filter to the fields in the data source
and display only the fields that equal the value of the
other list box control on the form.

Theres a good example on www.infopathdev.com - repeating
and cascading lists.