I am trying to write a
simple address book program as an exercise. I created 4 folders. The
hierarchy looks like this:
Country
State_Province
City
Address
Each country contains one or more
states/provinces. Each state/province contains one or more cities.
Address folder is at the same level as Country folder. Country has only
one attribute: name. State has two attributes: name and countryid.
City also has two attributes: name and state_provinceid. Address has three
attributes: street, cityid, and type.
In the Address form, I have a
1. textarea box
to collect street info
2. select/option box to collect address type
info
3. button, when clicked will open a new window to show a list of
cities. In the City List, there is one button next to each city to allow
users to select it.
The question is how to show whatever users has
typed in the street textarea box and the city, state, and country names in the
Address form after an user has selected a city. I know how to call SQL
method to join city, state, & country tables. Most importantly, I
don't want to save the Address to the table until the City is
selected.
Regards,
Ping