Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-23-2019, 07:07 PM   #16
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,946
Thanks: 13
Thanked 1,533 Times in 1,459 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Table Design Multiple same name cities in state

You also cannot have the same city name twice in the same state. So although I would use an autonumber as the ID for the city table, I would have a unique index on StateID + CityName to prevent duplicates.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 08-25-2019, 02:06 PM   #17
BigHappyDaddy
Coding Monkey Wanna-Be
 
BigHappyDaddy's Avatar
 
Join Date: Aug 2012
Location: Puyallup, WA
Posts: 205
Thanks: 6
Thanked 38 Times in 37 Posts
BigHappyDaddy is on a distinguished road
Re: Table Design Multiple same name cities in state

Not to sound like a know it all a$$, but I (quickly) did some research and there are a few examples of same city names in a single state. Seems that Springfield, PA exists in two separate counties.

Lots of other examples that are very similar, but not exact.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
BigHappyDaddy is offline   Reply With Quote
Old 08-25-2019, 06:27 PM   #18
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,238
Thanks: 86
Thanked 1,623 Times in 1,506 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Table Design Multiple same name cities in state

Yes, unfortunately that city duplication happens now and then. Could be worse, though. You could have to try to spell some of the Louisiana town and city names that are French spellings of Choctaw names.

My comment about ZIP codes also has an issue since if the city is large enough, it might cross into multiple ZIP code areas. So you would have to list only the code for that city's Town Hall or City Hall or Municipal Office building or whatever they call it. Otherwise you would have New Orleans with not less than a dozen different codes at once.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 08-25-2019, 06:59 PM   #19
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 860
Thanks: 10
Thanked 181 Times in 171 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Table Design Multiple same name cities in state

Quote:
Originally Posted by BigHappyDaddy View Post
Seems that Springfield, PA exists in two separate counties.
Out of curiosity I checked but cannot find a Springfield PA that is not in Delaware county. Do you have any links that expose States with duplicate city names?
Micron is offline   Reply With Quote
Old 08-26-2019, 05:25 AM   #20
BigHappyDaddy
Coding Monkey Wanna-Be
 
BigHappyDaddy's Avatar
 
Join Date: Aug 2012
Location: Puyallup, WA
Posts: 205
Thanks: 6
Thanked 38 Times in 37 Posts
BigHappyDaddy is on a distinguished road
Re: Table Design Multiple same name cities in state

Sorry, but no links handy. But I believe it was Delaware county and Montgomery county. One was directly west of Philadelphia, the other was north.

Another (possible) is Red Bank, AL. But I have NOT researched that example.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
BigHappyDaddy is offline   Reply With Quote
Old 08-26-2019, 06:32 AM   #21
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 860
Thanks: 10
Thanked 181 Times in 171 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Table Design Multiple same name cities in state

I see why, I think. One is Springfield, the other is Springfield Township. Locals in the latter location might just refer to their base as Springfield, but Township is part of the name. You would have to enter Springfield Township in the table field because that is the correct name (or so I gather from Google). I'll leave it to someone else to figure out Red Bank if they're interested.
Micron is offline   Reply With Quote
Old 08-26-2019, 06:59 AM   #22
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,946
Thanks: 13
Thanked 1,533 Times in 1,459 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Table Design Multiple same name cities in state

My mapping apps find only one Springfield in Pennsylvania and no Red Bank in Alabama.
According to the Wickipedia, there are no cities named Springfield in Pennsylvania but there are 9 townships named Springfield Township. The Post Office recognizes two places named Springfield, both are close to Philadelphia and one of them (southernmost) is the one recognized by Google and MapQuest as a real place.

I would get a list of legal cities from the Post Office. Those are what you need for mailing addresses. If you include county with city, I think that makes the two unique but I didn't get the official city list from the USPS.

Code:
Municipality	County	212 Population
Springfield Township	Delaware	24,255
Springfield Township	Montgomery	19,484
Springfield Township	York	5,268
Springfield Township	Bucks	5,047
Springfield Township	Erie	3,413
Springfield Township	Fayette	3,017
Springfield Township	Mercer	1,976
Springfield Township	Bradford	1,120
Springfield Township	Huntingdon	651
Attached Images
File Type: jpg SpringfieldPA.jpg (79.9 KB, 14 views)


__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Greetings from the Twin Cities WhipStitch Introduce Yourself 1 07-29-2017 05:30 AM
Multiple entries in one field? If not, how should I design the table? zhypaul Tables 4 02-20-2013 09:55 PM
multiple tables reffering to city, state, zip balfoura Tables 10 06-08-2009 06:49 PM
[SOLVED] Table Design - Multiple Fields ellford Tables 1 12-29-2005 07:57 PM
break up city,state zip to multiple fields threeo2 Forms 3 01-21-2004 08:06 PM




All times are GMT -8. The time now is 03:55 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World