InfoPath Dev

 I need to change the Secondary Data Source for a repeating section, however, get the following message "binding a non-repeating field or group is not supported in SharePoint list forms. to fix this problem, bind the control to a non-repeating field or group." Need to rebind all fields: Primary Location, Course Manager and Program Manager in Course Info section bound to "Courses TQMS " changed to "Active_Course_Info_for_IP_forms". How do I fix this issue? See attached template. Thank you in advance

Start from the section, then re-bind the fields. So, right click the section, change binding, select the repeating section from your new data source. Then after you have done that, you can rebind each field.

How do you filter the section so only the values corresponding to the CourseCd appear in the section?

I would probably just query for the correct rows - so set the data connection to not query data on load, and on the course code drop down, add rules that set the course code query field in the data connection to the selected code, then query the data source. Or, you can add a formatting rule to the repeating section - just hide rows where the course code doesn't equal the selected course code. Let me know if you need me to update your form w/ this to better explain. :)

Thanks, you gave me enough information to let me figure it out, different way of thinking to get the repeating section working, at least for me anyway. I had to run the query on load because it affected another drop-down, but got it working. I had to think about it a little bit. Thanks again

You bet - glad you got it working the way you need it to. Yeah, if you are already using the data source for something where you need all the rows, you just have to hide the rows you don't need. :)