autofill data from one table to another


G

Guest

I have a database or table that is basically a modified mailing list. In
that I have categories for name, address, city, state, zip and I need a
category for the county, which I have created but I need the county data to
fill in based on the zip code. I also have a separate zip code database or
table that has the county information in it, but I cannot figure out how to
have the mailing list database pull the county automatically from the zip
code database. Thank you anyone who can help.
 
Ad

Advertisements

G

Guest

When you say the zipcode database or the mailing list database...are they
actually separate databases or are they separate tables within the same
database?

If they're separate tables within the same database I'm assuming that they
have fields similar to:

tblZipCodes
-------------
ZipCode
City
County
Etc...

tblMailingList
---------------
Contact
Address
City
State
ZipCode
County
Etc...

If that's the case you can use the domain aggragate DLookup to enter the
appropriate county.
 
G

Guest

Sorry, pushed the post button too quickly. Unless it's absolutely necessay,
you shouldn't copy data from one table to another if the data you need is
always available to extract.
 
Ad

Advertisements

G

Guest

If the data that you want is in another sql database (it has a different file
name or is in a different location) you can use the Linked Table Manager to
link the table that you want to extract data from into the current database.
Once the table is linked it acts just like any other table that resides
within the database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top