InfoPath Dev

Hi,

I'm designing a DIP form for Word 2007, using Infopath 2007. I've got 2 drop-down list boxes (Category, Product) connected to Sharepoint list.

Hi -

Your main data source node isn't repeating, so current() shouldn't come into play.

I just tried this - and my drop downs cascaded nicely:

/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Category = xdXDocument:get-DOM()/pr:properties/p:properties/documentManagement/ns2:Category]

So, what I'd check first is that the "Category" in the CategoryRelationList node actually has matches for the value in your main data source Category field.

Drag the repeating node from the data source you are using for your Product dropdown onto your form so you can see the data. Drag your main data source Category field onto your form (as a text box) so you can see the value there. Then preview the form - is the value in your main data source Category field the same as what you are seeing in the Category column for the data source you are using for Product.

Your main data source needs to be populated with a Category ID, it sounds like, from your error. Does the list with Products use a look up for the Category? That is, is that list storing category names or IDs?

Hi, Hilary

Thank you for your answer. I did as you said - drag the repeating node from the data source and drag my main data source Category field onto form (as a text box) and preview it.  Main data source Category field value for first choice ( possible values: Hardware, Software) is 1, repeating node value is  Hardware - so I guess this is the problem.

If I change Category drop-down box properties from Value:@ID to Value:@Category, then preview shows that values are correct in both nodes, but in main data source Category field I've got a red mark (only positve integers allowed). Yes, I've got lookup. CategoryRelationList has 2 columns (Title, Category) and Category column is lookup in other sharepoint list CategoryType.

        TITLE          CATEGORY

• Keyboard      Hardware
• Mouse          Hardware
• Office            Software
• Windows       Software

I'm trying to implement cascade dropdowns in sharepoint document library, so I did it with JQuery & SpServicesCascadeDropdown - I've added some code in editform.aspx (that is the reason why I have 2 lists with lookup). That solves the problem when I upload a document, but not when I create a new document in library, so I've got to solve it with content type and editing DIP with Infopath.

Regards,

Klemen 

So, the XPath for your filter gets a little more complicated, because you have to get the display name for the ID in your main data source category field in order to find the correct products.

Can you attach your template to a reply, under the Options tab?

Hi,

Here it is.

Regards,

Klemen

Currently your Category and Product dropdowns are using the same data source - what data source were you originally using for the Category - I don't see one with fields of ID, Category as outlined in your original post?

 Hi,   

I guess I've done several teplates. My data sources:

CategoryType

       TITLE

• Hardware
• Software

CategoryRelationList

         TITLE          CATEGORY(lookup to TITLE in CategoryType)

• Keyboard      Hardware
• Mouse          Hardware
• Office            Software
• Windows       Software

Test (document library where I'm trying to implement cascade dropdown in DIP)

NAME          KATEGORIJA(lookup to CategoryType)           PRODUCT(lookup to CategoryRelationList)

For KATEGORIJA dropdown I was using  CategoryType data, for PRODUCT dropdown CategoryRelationList. I was also trying with one data source.

Regards

The filter looks like this in the version I'm attaching:

/dfs:myFields/dfs:dataFields/dfs:CategoryRelationList[@Category = xdXDocument:GetDOM("CategoryType 2")/dfs:myFields/dfs:dataFields/dfs:CategoryType/@Title[../@ID = xdXDocument:get-DOM()/pr:properties/p:properties/documentManagement/ns2:Kategorija]]

This is assuming the in the CategoryRelationList, the Category uses the Title rather than the ID for items from the CategoryType.

It works!

Thank you very much :)

Regards,

Klemen 

 Hello Hilary, can we have a cascade column but using only one list as lookup, I am seeing examples but all of them request to have two list. I would like to have one for example. What could be the way to link this into the form.

Column: Category

Columb: Subcategory

Lookup list: 

Category                 Subcategory

1                             1.1

1                              1.2

2                             2.1

2                               and so on.

3

3