Duplicate Records in multiple tables

[Krystoff]

Hello all,

This should be an easy thing to do but I am having a tough time trying to figure it out.

I have a table that can have duplicate people. I have another table that houses status on those people and it has duplicates as well.

What I need to do is to update the first instance of a person in the first table with the first instance of a person in a second page. Then I need to check for the second instance of a person in the first table agaisnt the second table to see if there is something there as well.

There should never be a case where there is no duplicate in the first table but a duplicate in the second table.

Any ideas on how to do this quickly?

Thanks!

 

[cottontop]

In the first table make a field the key field, like ssn or some other unique identifier for the person. The key field will not allow duplication.

The identifier should be in both tables. Then when you create a query with the two tables and automatic link will form.

Query off the the second table indentifier. If it's info is null, then there is not match in the second table to the first. If it's not null, there's a match.

Is this what you're looking for?