G
Guest
Hi,
I have the following tables that i need to link.
Table 1 "account table" has all the account names and client names and
account numbers,e.g
Field 1 Field 2 Field 3
a/c name client name client code
A/C#1 J. Smith 2242
A/C#1 T.Lock 4432
A/c#4 T.Lock 4432
A/C#2 J.Smith 3322
A/c#3 U.Whitney 9789
Some clients invest in more than 1 account names and have more than 1 client
code. Some clients have the same client code and are in different account
names. This cannot be changed.
Table 2 has the account name and client name but no client code with other
data.
I have tried to link the tables - (there is no PKey) with the client name
and account name but it doesn't seem to work. Can some one suggest a way to
write a query that grabs the client code from table 1 and all the other data
from table 2?
Thanks
George
I have the following tables that i need to link.
Table 1 "account table" has all the account names and client names and
account numbers,e.g
Field 1 Field 2 Field 3
a/c name client name client code
A/C#1 J. Smith 2242
A/C#1 T.Lock 4432
A/c#4 T.Lock 4432
A/C#2 J.Smith 3322
A/c#3 U.Whitney 9789
Some clients invest in more than 1 account names and have more than 1 client
code. Some clients have the same client code and are in different account
names. This cannot be changed.
Table 2 has the account name and client name but no client code with other
data.
I have tried to link the tables - (there is no PKey) with the client name
and account name but it doesn't seem to work. Can some one suggest a way to
write a query that grabs the client code from table 1 and all the other data
from table 2?
Thanks
George