Matching records from two different Access tables

Hi all,

Bearing in mind I’m a relative newbie (esp. with VBA) could you possibly suggest a simple (or at least describe it in a simple manner) solution to this problem.

Table1:LabCases
FirstName
LastName
DOB

Table2:EpiCases
FirstName
LastName
DOB

Now, there are likely to be things like mis-spellings etc, so what I need to do is show a form that has the information from table 1 in it, and asks “is this case the same as” and displays the information from table 2 in it. Then, when I say “yes, these two are the same” (i.e. some form of mapping etc.) a link is made that knows the information refers to one person.

Er. How???

Any ideas? ANY?

Many, MANY thanks in advance for any help or direction provided.
Naomi