InfoPath Dev

I worked around this by putting a refresh button in each row to query the data and set values again based on existing project name.  This is not ideal however.

I’m using InfoPath 2010, but designing a browser-enabled form downgraded to InfoPath 2007.I have a project form with a secondary data connection to a SharePoint list.  I have a button to Query for Data. I am using a repeating table. Project_Name Project_Status Initial_Date Current_Date Test project ...

Hi,  Thanks so much for the quick response and sending the sample!  I never saw that "Filter data..." button when selecting the field or group until I worked through your example.  Works great.  Awesome!  THANKS!!!

I have a simple repeating table with two fields.  The first is a drop down list with status selections of "New", "Pending", "Approved", and "Rejected".  The second is a text field where users enter a dollar value.  I want to sum the dollar amounts in the footer of the repeating table for text ...