InfoPath Dev

 Thank you so much Hilary. That works. Just a matter of changing the date first prior to clicking insert. As for the Query field I am not even sure but I will remove it now :) Thank you once again you are a star.   

Hi Hilary, Thank you for your quick replay. I don't actually have a drop down date box, I have a Datepicker. So like in your example Select the date and the Course Title will go into the Calculated field next to your drop down. That Course will then flow into the Course in the repeating table. But in my form when I change ...

Long time reader first time poster: Newbie question I hope. I am creating a InfoPath form, from 2 SharePoint List. I have 2 data connections to two separate lists, and one XML schema connection. The form has a repeating table section and a non repeating table section. In the Non repeating section I have 2 columns a Date picker (Date) ...