Avoiding Duplicates

[Mickey]

I have two seperate tables that do seperate functions. I want to be sure
that one table does not include the same information in the second table. Is
there a way to keep one table as the primary table and the other contain no
duplicates located in the primary. If there are duplicates already is there
a way to find them and delete them?

 

[Klatuu]

Are the fields in the two tables identical?
If so, the best practice is not to use two tables, but one table with a
unique primary key (an auto number field is godd for this) and a field to
identify to which group the record belongs. Then use queries to retrieve the
data you need rather than the table itself.