InfoPath Dev

 Attached form, I need to populate the Fields in the Repeating Section under "Quotas": "Avail AD" to "Avail CGNC" based on the "Course Code" dropdown box selection. I will then add these fields to populate the "FC-Bop AFC56 Student Quotas Available". Hilary Stoupa fixed my problem with the Course Info Section, but I am not able to get the Quotas section working. I tried a number of different things and searches, webinars, but I need a better understanding of how to set up these sections. Any assistance will be appreciated. Thank you in advance

 Hi! So here's your form back with some changes - hopefully some of them are right, since I'm guessing a bit. On the Form Load & the Course Code field, I have added rules to query for the right course code for the data connection that the Quotas section is bound to. Since we are only querying for those that match on course code (based on what your data connections look like - I'm not sure if your lists actually match), you should only get back the row(s) that match. Then, I added another rule to populate the student quotas available field.... I moved that field out of the secondary data source repeating section, however. And if your secondary data source may return more than one row for each selected course code, you'll want to change the formula to sum each field from the 2DS prior to adding them up.

Thanks again, I was able to get the other fields working also, and have a better understanding of the functionality.

Wonderful, that's half the battle. InfoPath got a lot easier to me when I started dragging my data sources onto the form where I could see them while I was doing my design work, by the way. Just make some room at the bottom of your form and put whatever you need on there to see what's going on - you can delete it all when you get ready to go live. Then when you preview you can actually see what is happening. :)