compare and update table

[Guest]

I have a database of people and fax numbers which we use for market survey
recruiting. I have set up a linked table to track individuals/fax numbers who
do not wish to be contacted further (a thousand or so opt-outs). We wish to
purchase an update to the fax database and maintain the list of opted-out fax
numbers from the old list. How can we compare/search for these opted-out
individuals/fax numbers from the opt-out list table in the new fax database?
We'd like to either link the old opt-out list to the new fax database or
create a new, linked opt-out list. I'd be grateful for any suggestions!

Thanks,

Matthew Smith

 

[margaret bartley]

I have a database of people and fax numbers which we use for market survey
recruiting. I have set up a linked table to track individuals/fax numbers who
do not wish to be contacted further (a thousand or so opt-outs). We wish to
purchase an update to the fax database and maintain the list of opted-out fax
numbers from the old list. How can we compare/search for these opted-out
individuals/fax numbers from the opt-out list table in the new fax database?
We'd like to either link the old opt-out list to the new fax database or
create a new, linked opt-out list.

I'm not sure I understand the question.

Are you saying you have four tables: an old fax list, and old opt-out list,
and a new fax list and new opt-out list?

You can either run an append query to add the opt-out numbers from your
old list to your new list, or you can create a union query, and use that as
your
opt-out list.

 

[Guest]

Thanks Margaret. To clarify our situation, we have an old fax list table and
linked opt-out table with a Yes/No field called "Contact_again?". We want to
purchase an updated fax table and use the old opt-out list table to either 1)
link to the new table (via the Contact's Name) and use as the new opt out
list or 2) create a new equivalent opt-out list table, linked to the new fax
list table.

I'll have to read up ou your proposed solution(s). It seems you may be on to
something.

Thanks,

Matt