Auto Enter County, State & Zip after entering City

Scottgem [MVP] wrote in

news:*** Email address is removed for privacy ***

m:

I'd rather have a newbie understand about normalization and then decide when it is overdone then confuse them with the

concept of overnormalization.

I think this is an extremely ill-chosen example for normalization as

in most apps, it won't be an appropriate structure.

David W. Fenton                  http://www.dfenton.com/ contact via website only     http://www.dfenton.com/DFA/

When I create the form, will there be a way to use a drop down to select my city from a list and have it populate whatever else I want it to in the other fields?

Yes, See my blog on Displaying Data from other tables. You can adapt the techniques to populate the other controls.

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2010 Blog: http://scottgem.wordpress.com Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

There are only two cities with the same zip, and 98% of the time it's only one of the two.

I'm working on moving the actual address from the individual records table to an address table. Next I'll have to create a form to do my entering on rather than going back and forth between two tables for entry (like excel).

When I create the form, will there be a way to use a drop down to select my city from a list and have it populate whatever else I want it to in the other fields?

Reach,

Please DO ask for clarification of any term we use that you don't understand. You might also want to check out www.hplearning.com. HP offers free courses that are instructor monitored by partially self paced.

The way to get around the issue of multiple cities/towns with the same zip code is to use an Autonumber Primary Key for the Zip Code table. When you select a zip code you can display the city as well so the user can choose the correct city. I also generally do store the City, State and Zip in the address record, but sometimes not. Really depends on the app.

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2010 Blog: http://scottgem.wordpress.com Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Some cities have multiple zipcodes. How can you type a city and populate a zipcode?

See Post Office site here:

http://zip4.usps.com/zip4/citytown.jsp