July 19, 200718 yr 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?
Create an account or sign in to comment