How to select the good street?

[El_Pablo]

Hi,

I've done a database which contains mailing adresse with streets that belongs to city.

Here's the schema:

Mail (pkMailID, fkStreetID)

Street (pkStreetID, name, type, direction, fkCityID)

City (pkCityID, name)

The question is how can I select the right street in the good city?

Let say the user enter the street and after the city. How can I make fkStreetID be entered automatically?