InfoPath Dev

I have looked over your suggestions. The simple test form looks good and may give me useful ideas for the future, however neither seemed to meet my current needs and I am even starting to rethink some of my overall design philosophy because I'm starting to think it may have performance problems in the future. Basically my form has two parts. ...

 Yes, you are correct, the conditional formatting is just hiding the data showing in the form. That was the only way I could get only the rows to display that I wanted.  So my questions in relation  to your suggested options are: 1.  I'm not sure how to modify the query for the results directly from the Db. Are you ...

My repeating table, linked to a database,  has conditional formatting to only return rows meeting my criteria and it displays correctly. I have added a "total" field in the footer to display the sum of values in the records. However, it displays a sum for all records in the database, not just the ones that are returned with the ...