How to filter data from a secondary data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cyril - 28 Oct 2004 12:37 GMT

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

Reply to this Message

Ben - 28 Oct 2004 16:06 GMT

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?

Signature

Thanks
Ben

> I have a sharepoint site with a form librairy.
> I added my sharepoint list to the the secondary data source, then I dragged
[quoted text clipped - 7 lines]
>
> Cyril

Reply to this Message

Greg - 29 Oct 2004 00:55 GMT

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.

>-----Original Message-----
>I tried to do this by
[quoted text clipped - 25 lines]
>
>.

Reply to this Message