Find not finding what it's supposed to
apologies for posting an oversized screenshot, I wanted all the pieces of the puzzle to be visible.
In short, I'm trying to make a script, whose functionality depends on the Find step finding the appropriate record.
In the screenshot you can see that my CustomPrice table contains a record with ProductID of 1 and BusinessPartnerID of 2. You can also see that the step right before the Find shows a custom dialog that displays the values of the two variables. The dialog box confirms that the value of $$ProductID is indeed 1 and $$BusinessPartnerID is set to 2. The screenshot does not show this, but I hope you'll take my word for it.
Yet the search performed in the next step finds nothing. How is this possible? What is it that I'm missing? What other factors could affect the result of the search?