Great instructions! I follow them and I do get the text boxes to populate with the correct data that corresponds with the selection in the drop down box. However, I have 2 issues that I am having trouble with. I am using SharePoint 2010 and InfoPath 2010. I have created a list form in IP and I have 2 drop down boxes in the form that reference 2 different SharePoint lists. I have followed the steps above and both populate the corresponding text fields correctly but they both are exhibiting the following behaviors:
- Before anything is selected from the drop down list, the corresponding text box is already pre-filled with the data for the first item in the drop down lists. So, the drop down list is blank (from the blank 'default' item in the drop down list). How do I fix that so the corresponding text fields are blank until an option is selected from the drop down box?
- Once a selection is made in the drop down box, the correct information populates in the text box however, if I selected the wrong choice in the drop down list and I want to go back and change it to the right choice, the only options listed in the drop down box are the default blank option and the incorrect one that I chose. Now, if I select the blank option in the drop down box, the drop down list repopulates with all the options but the corresponding text field defaults back to the issue I described in #1 above.
What am I doing wrong? In this state, the form feels clunky and I don't really want to publish it for use.
Thank you,
Tracy