Zip Code Table

[Taylor Francis]

How can I use a table of zip codes which needs to link to multiple
tables? For example, A list of businesses links to it and so does a
list of individual contacts. How does that work in the relationship
setup. I tried just doing direct links, but Access wanted to use the
zipcode table to link individuals to businesses.

I'm relatively new to Access...what am I missing?

Taylor

 

[Joseph Meehan]

How can I use a table of zip codes which needs to link to multiple
tables? For example, A list of businesses links to it and so does a
list of individual contacts. How does that work in the relationship
setup. I tried just doing direct links, but Access wanted to use the
zipcode table to link individuals to businesses.

I'm relatively new to Access...what am I missing?

Taylor

What exactly do you want to do? Do you want to look up customers and/or
businesses by their zip code?

 

[Taylor Francis]

Basically, I just want to not have to type in cities and states
repeatedly...I just want to type in the zip and then when I print
reports, access will fill in the city and state. (I suppose it can do
that on forms too...)

Taylor

 

[John Vinson]

How can I use a table of zip codes which needs to link to multiple
tables? For example, A list of businesses links to it and so does a
list of individual contacts. How does that work in the relationship
setup. I tried just doing direct links, but Access wanted to use the
zipcode table to link individuals to businesses.

I'm relatively new to Access...what am I missing?

Taylor

How are you trying to create the link? Do you have a Zips table with
one record per zipcode, using the zip as its Primary Key? You should.

I'd suggest just having a Zipcode field in your Addresses (or
Businesses, or Contacts) table; in the Relationships window, drag the
Zip from the table of zipcodes to this field, and make it an enforced
one (zipcode) to many (addresses) relationship.

You certainly would NOT drag the zip field from the Businesses table
to the Individuals table, if that's what you're doing!

John W. Vinson[MVP]

 

[Taylor Francis]

Nah, I tried to drag from businesses to tblZipCodes and then drag from
contacts to tblZipCodes....

Weird things happened then...

 

[Al Camp]

Taylor,
Please don't double post. There are now 2 groups of people working on your question,
each without knowledge of the other.
See my response on to your most recent post.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Taylor Francis]

Sorry... I posted the first one and it didn't show on my computer for a
long time. By then I assumed something had messed up, so I sent
another... Didn't mean to double post...