Linking two tables

[mohd21uk via AccessMonster.com]

I have two tables. One of them is called tbl_CATS while the other is called
tbl_Contacts. I have a field called LastName and another Field called
FirstName in tbl_Contacts and I would like to match this with tbl_CATS
Username.

Is there a querythat could do this ?

 

[Marshall Barton]

I have two tables. One of them is called tbl_CATS while the other is called
tbl_Contacts. I have a field called LastName and another Field called
FirstName in tbl_Contacts and I would like to match this with tbl_CATS
Username.

Is there a querythat could do this ?

Probably not unless you can guarantee that all people have
unique names (nonsense) and that your users can not make a
mistake when entering the names in to the different tables
(also nonsense).

If you could arrange for a unique identifyer for each person
that would connect the records in a unique way, then it
would just be a matter of Joining the two tables on that
unique identifyer.