Filter a secondary datasource with infopath 2007

[Makor]

I am using Version 2007 and was wondering if this problem still exists. Here
is my situation.

I have one form with a main data connection that updates transactions. I
have many other secondary datasources that all work fine with dropdowns and
filtering. For instance when I select a certain category in one drop down
only the products for that category are listed listed in dropdown 2. I need
this to work for a repeating table.

I have a text box above my repeating table that I want the user to enter in
a lot number. In my repeating table I only want to display the data that has
a corresponding lot number. This data can still be in the data source I just
don't want to display it to the end user.

There has to be away to accomplish this.

Please respond as soon as possible as this is a pressing issue and if we
cannot fix this we need to find another solution.

Thanks

If there is not solution can you please explain what the thought process
behind this was and maybe that will enlighten me to use another way.

or show me in more detail how to modify the xsl file in order to pretend
this is main datasource.