InfoPath Dev

You have been a great help, thank you so much.  :) I brought in the Default-Values SP list I created as a secondary connection, and am attempting to modify the Set Currency rule XPath you left as an example, but it is only bringing in the same value for Payment Terms (Payment1 in the form) for all Sales Orgs.  Is it clear to you what I ...

The reality of the situation is that many of these fields are country driven, since there is a many to one relationship between Country and Sales Org, as you can see by the screenshot displaying so many Puerto Rico Sales Orgs for Latin American countries.  To answer your question, after conferring with another team member, I modified ...

  I removed the submit for field8 it was put in by a coworker trying to help.  Yes you are right about the data connections and no I do not need the 103 data in the calculated fields I do need the calculated fields to populate according the selection in field8. It seems that the cascading dropdown negates the ability to do that. I ...

Ok, thanks - so the options in field8 are unique, regardless of what is selected in 103? Are there a lot of list items that would match on field8 in the list? Is the data you are seeing in your calculated fields just entirely wrong, or earlier data, or blank? Because your XPath looks right for selecting items that match on field8, but if there are ...

I'm confused by why on field8 there is a rule to submit the form? Is that what you want to do? It looks like maybe the main data source of the list and the secondary data connection for those calculated values are the same list.... So - the data you want to show in those calculated values would be the most recent data submitted with the same ...

InfoPath is going to use XPath notation - the period is normal. https://www.w3schools.com/xml/xpath_syntax.asp for more. I don't understand this: "If I have it pointing to the sharepoint library it will not pull the data" - I don't know what that means. If your data connection is setup to use a resource file from the form, the ...

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

Ahh, it's all so clear now - think my head must have been clouded from staring at notepad too long! When I looked at both again I realised that in my code I had failed to refer to the actual "Authorised" group, I was able to solve the problem by simply changing it to: <Authorisation Funding="No" ChequeValue="Under ...

You need to filter on both, I think, looking at your data. You could probably set the country query field in your new list data connection and query that when the user changes the country, in order to only return data pertinent to that country. Then in your XPath for your rules to set field values you could add the Sales Org filter.

Well - there isn't any restriction on the number of cascading dropdowns, so I'd suspect the issue is with the filter you have on your third dropdown. Can you attach a copy of your form under the Options tab in a reply so I can see what you've got for a filter?