InfoPath Dev

What is the field name for the country field in question? I see a number of labels on the form with the word "Country" and want to make sure I'm looking in the right place. If the data source for the sales org dropdown contains the country, we should be able to set that with a single rule, just using XPath to get the correct sales ...

So I discovered something very weird and I dont know how to explain it. I had gone back to my rules to clear the cascading history and saw that in the sub group i had this . Just a period, when I removed it nothing would populate the dropdown. If I put it back i got the previous selection but all of the rest of the selections. I have ...

Without seeing the form with the XML resource file I can't begin to guess. Have you opened the XML in a text editor and searched for "#N/A"? I think in another post, you talked about creating this XML from Excel - #N/A is a common error in Excel, like when a VLOOKUP doesn't return a value. In the last version of the form I looked ...

Your filters look right. The issue is how you've configured your dropdowns, I think. Right now, you have the value and display set so that the Service dropdown will store a Network value, and the Team dropdown will store a Service value. That is why your filter on Team isn't working - the value stored in Service is going to be a Network, ...

Yeah, that's the formula I have been trying to get to work on both the check box as well as the drop-down Country4, to no avail.  :)  Which simply means no value is populated in Edoc_Delivery_Notes when the check box is ticked, nor when a value has been selected from Country4.  The formula resolves fine without any errors ...

We can use the ID from the main data source sales org to look up the text in the Sales Org 1 data source for the comparison. So, no, you don't have to use XML or contains. That's why I'm asking if the text value in the list that is used for the CMD_Pulldown is equal to the text value displayed in the sales org dropdown.

I was just wondering if there were values in there that correspond to the fields you want to set. I've taken some guesses. Here's a copy of your form, save it locally, right click and preview and we'll see if I've made any correct guesses. I can't test my changes in preview because I don't have access to your site, of ...

It works.  :) Well, for SalesOrg anyway.  Again, there are no linear relationships in the CMD_Pulldown SP list.  It is only a repository of columns and column values stored vertically (think Quick Edit for adding new values to a column).  No list items here make any sense. That being said, I kind of understand the XPath ...

Yup - as long as you have a way to relate the sales org. If your list stores the text value, you just have to have the additional filter to get that text from the secondary data source leveraging the ID that is currently stored in the main data source. The XPath looks hairy, but it is just matter of adding a filter and selecting the filter values ...

What about these rules on the use default sales org values selection? I see the rules are using "contains" - but it looks like if I have the sales org, I can get the values from the CMD_Pulldown data source. Does the sales org in that data source match the name of the selected sales org? Or do we have to use contains here?