Very new to infopath here, and I have come across a few situations similar to this but haven't found my answer. It seems that this has to be done with code, but if anyone can point me in the right direction that would be great.
I have a form pulling from an SQL DB.
On the form I have a drop down list that contains an action to set the repeating table based on the selection. I have then set up a conditional rule 'hide' all rows that do not match the drop down list selection.
All is well except that I have large sections of blank rows between the displayed selections because they are simply hidden and not removed.
Is custom code truly needed for this? Or is there a more simple way to achieve a list of results without blank rows between?
thanks in advance.
-SR