autofill data from one table to another

[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.

 

[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.

 

[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.

 

[Guest]

how can I extract the data from one database into another?

 

[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.