Entering Zipcode, another table enters city and state

[JR333]

I have a customer table and a zipcode table that gave zip, city and state. How can I have a default value entered (after entering the zipcode) for city and state (and allow the user to change it in the record if the city and state is wrong).

I know I can just use two tables in a form. But we have a few international customers so all values aren't defined in the zipcode database. That is why a default value would be prefered.

Can anyone give me some suggestions?

 

[hermanlaksko]

First of all I would turn the 2 tables into one then I would add a country code, having the defoult country set to "US" this should do the trick