Combining information from linked tables

[Guest]

Please bear with me - I am new to this

We do not / cannot afford MS Server but I want to be able to combine names
and address from our ACT database and our personal contacts. THere are only
two of us but we have duplications etc and we need to do a mail out.

I have linked the three tables and can see the contents but how do I now
create a table that will allow me to ensure there are no dupilcates and to
bring all the information together ?

Thanks

 

[Albert D. Kallal]

Are you talking about importing this data into a ms-access table?

You could simple create a table with a index on the name field and address
field.

When you append the data from 3 tales into this one table, no duplicates
will occur....