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
