Linking two tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mohd21uk - 31 May 2006 15:20 GMT

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 ?

Reply to this Message

Marshall Barton - 31 May 2006 18:34 GMT

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

Signature

Marsh
MVP [MS Access]

Reply to this Message