M
Mike C
Hello:
I am relatively new to access, though vaguely familiar with database
concepts and Access jargon (i.e., queries).
I need to do the following (see below) and I was hoping someone could
tell me what is the best way (at a high level) to do this in Access.
I have a large list of names and addresses thrown into a single flat
table. There are many duplicates in the file. Somehow, I need to
separate duplicate addresses from the file and place them in another
table so that I can link the list of unique names to the addresses
(i.e., a one to many relationship).
My end users will be using the database to lookup the many addresses
for one the unique names, AND to mail out mail to each of the unique
addresses.
Is there a "best way" to set this database up to accomplish this?
How can I separate the flat file so that the many addresses can then
be linked to the individual names?
Thanks for any suggestions.
I am relatively new to access, though vaguely familiar with database
concepts and Access jargon (i.e., queries).
I need to do the following (see below) and I was hoping someone could
tell me what is the best way (at a high level) to do this in Access.
I have a large list of names and addresses thrown into a single flat
table. There are many duplicates in the file. Somehow, I need to
separate duplicate addresses from the file and place them in another
table so that I can link the list of unique names to the addresses
(i.e., a one to many relationship).
My end users will be using the database to lookup the many addresses
for one the unique names, AND to mail out mail to each of the unique
addresses.
Is there a "best way" to set this database up to accomplish this?
How can I separate the flat file so that the many addresses can then
be linked to the individual names?
Thanks for any suggestions.