InfoPath Dev

Hey Hilary, Thanks for responding  :) I have attached the form in question.  Please note that in order to simplify my post before, I claimed "State" was the third tier of the cascading drop-down.  In actuality it is SalesOrg.  I just didn't want to go into explaining what that is, but it is a field specific to ...

CMD_Pulldown is a SharePoint list that is being used for the values of a handful of columns (that have no relationship as list items).  Formerly, it was being used for Country and Sales Org, but I have since created separate lists in order to tackle the cascading drop-down function.  Yes the values are the same between these two columns ...

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 ...

 From my initial post: "Please note that I am unable to use "=" (instead of "contains") and "Type text..." here for the value, since this is a drop-down value and it is being seen as an integer I believe (ID?).  With an operator of "=", I only have these options: "Type a number...", ...

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 ...