Linking two tables

  • Thread starter mohd21uk via AccessMonster.com
  • Start date
M

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 ?
 
M

Marshall Barton

mohd21uk said:
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 ?
Click to expand...


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.
 
Top