Hi Scroll,
The solution can be implemented without using code, but the filtering cannot be done on the sharepoint side, it has to be done on the infopath side.
Let's assume for my response that we have a dropdownlist on the form called EmployeeType. The dropdownlist contains 2 items "Programmers" & "Engineers".
Implement the following steps on the repeating table holding the SharePoint data:
[1] Double-click the Repeating Table to open its Properties dialog box.
[2] On the Repeating Table Properties dialog box, click Display, and then Conditional Formatting.
[3] On the Conditional Formatting dialog box, click Add.
[4] On the Conditional Format dialog box, add the following condition:
@EmployeeType (from SharePoint list) is not equal to EmployeeField (Dropdownlist)
[5] On the Conditional Format dialog box, select the Hide this control check box, and click OK.
This tells infopath to filter the repeating table and hide everything that does not match the selection in the dropdownlist.
[6] Click OK on all open dialog boxes.
[7] Test the InfoPath form template.
I managed to create this solution using some of the steps in the following article:
Hope it helps.