Question: Regarding Infopath 2007 Drop Down Box and SharePoint Li

[Chris Kubik]

I have a unique problem that I just can't get to logicialy function perhaps
someone can offer some assistance (any help is appriciated, thank you in
advance)

I have an infopath 2007 form (not web form, regular) and it uses a data
connection to a list in sharepoint. Specifically this data is used in a
serries of drop down boxes that I would like to cascade the data in.

What I'm trying to do is filter down categories as each selection in a drop
down box is made.

For example

The first drop down box asks for a 'Category'. Each entry in the sharepoint
list has one of 5 categories attached to it, so this box shows the 5
categories (Data Connection to sharepoint with (show only unique entries)
trigger selected.

The next drop down box (the one Im having a problem with) should show all
the items in that sharepoint list that are attached to the selected category.

For example if you select Category A, all the items in Category are shown.

What I have been able to acomplish is the filtering but it only works for a
single item. Another words when you select category A it shows 1 item from
category A as an selectable option in the second drop down box. I believe
this is because its using the ID of the entry in the list as a filter and not
the actual category.

I'm not sure of a way to make this work. Does anyone have any suggestions.

 

[Frederik Van Lierde]

Hi

It is rather simple to manage this.
I will try to explain it in some steps

1. Create your first dropdown (Category ).
Properties: List box entries: Look up values from an external
Data Source
DataSource: Your data connection
Value: Category ID
Display Name: Category Name

2. Create your second dropdown
Properties: List box entries: Look up values from an external Data
Source
DataSource: Your data connection (Same as used in point 1)
Entries: Select the repeating node, + click on Filter Data
Add filter condition
Category is equel to (Select a field or group) -

select Main + the binding field of the first dropdown

Value: ID
Display Name: Name


I made a test here, and it works.

Frederik Van Lierde
http://www.SilverSandsAssociates.com
http://BlueBizTalk.blogspot.com