Dependent dropdown and autofill

Hi All,
this question pertains to autofill and dependent dropdowns (using a database table as the source in the lookup wizard). I have two dependent dropdowns which work fine: the first contains streetnames, the second house numbers, ie if a street name is selected in the first dropdown, the second will present only the house numbers from this street.

Now, I wanted to fill two fields with values from the lookup table based on the house number in the selected street (selected by the first and second dropdown, respectively). But the resulting query seems to only honor the value from the second dropdown as a condition, so the result is not what I would expect. Am I missing something or is this just not possible?
Thanks