using one table to check another table's data

[genevx]

I have to check a field on one table to see if each record corresponds correctly to names on another table. Is there any way to open two tables as open recordsets to compare? Or is there another easier way? Please help and thanks! =)

genevx

 

[Val]

Genevx:

Can you use the Find Unmatched Query Wizard to give you all the records that don't match?

Val