Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Every example of a cascading drop-down in InfoPath is the same. A mostly blank form with just the two (or three) drop-downs taking part in the cascade. And it works...no problems there.

However, that is not real life. My form is an "Edit" form, where the user types in some sort of id and all the fields for the given "row" load into the form. Besides the simple types like Strings, I have two fields that need to be presented as drop-downs where the second drop-down is dependent on the first (hence the cascade). The problem is that the second drop-down is not loading until the user changes the first drop-down but I also need it to trigger when the value is changed when the "row" is loaded.

Here is the sequence:

  • The bulk of the form is loaded via a Web Service Secondary data connection. The user types in an Id and clicks a Load button.
  • The first drop-down is configured to execute the source query (another Web Service Secondary data connection) on form load so when the main portion of the form is loaded, the drop-down is already populated and the list item is set correctly.
    • The first drop-down also has a rule to be executed when the field changes. The rule sets a queryField for a third Web Service Secondary connection to the selected item in the first drop-down and then executes the query for that last web service.

The underlying problem is that InfoPath seem to consider the field being changed when the user manually changes it but not when changed by the initial form

share|improve this question

closed as not a real question by Anders Rask Jul 23 '12 at 11:22

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Please ask QUESTION and define your problem so that others could reproduce and answer/help –  Gennady Vanin Геннадий Ванин Jul 23 '12 at 3:34
    
Closed since it is difficult to understand what is being asked here. To get this Q reopened, please re-phrase with better description on what the problem is. In its current state you cant expect anyone to answer the Q. –  Anders Rask Jul 23 '12 at 11:23

Browse other questions tagged or ask your own question.