Did I fool myself

  • Thread starter Thread starter kkimsj
  • Start date Start date
K

kkimsj

Can some evaluate me? I am a noice at Access and to compound the
problem, am thinking like a programmer.I am having a devil of the time
with this idea:

I am using an email adress (in a field) as a way to link to a
"Contacts" Table. I have three tables -- customer, sales agent, and
service agent that have email "links" to the contacts table. In
complex queries, is there a notation I can use to reference. For
example,
I would like to get the last name of the Customer (like Customer.emall
--> contacts.lastname) and also the last name of the sales agent
(Sales.email --> contacts.lastname).

When I use the query design tool, I can't seem to get this to work.

Is this a fundamental design flaw by me or is there notation to get me
use the email address as a "pointer" to the contacts information?

I tied the on-line help and books but this seems to be too odd.

Thanks
Greg
 
Can some evaluate me? I am a noice at Access and to compound the
problem, am thinking like a programmer.I am having a devil of the time
with this idea:

I am using an email adress (in a field) as a way to link to a
"Contacts" Table. I have three tables -- customer, sales agent, and
service agent that have email "links" to the contacts table. In
complex queries, is there a notation I can use to reference. For
example,
I would like to get the last name of the Customer (like Customer.emall
--> contacts.lastname) and also the last name of the sales agent
(Sales.email --> contacts.lastname).

When I use the query design tool, I can't seem to get this to work.
Click to expand...

It is impossible to say what you are doing wrong. Did you add the three
tables to the query builder and draw the links between them?
Is this a fundamental design flaw by me or is there notation to get me
use the email address as a "pointer" to the contacts information?

I tied the on-line help and books but this seems to be too odd.
Click to expand...
You need to create joins between the tables. That word "join" should provide
you a lot of reading in the online help.
 
Back
Top