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