Two fields use the same table

T

Tod

I hope someone can show me the correct way to do this.

I have a main table with the data in it. It's not
normalized, but I don't have control over that. I have
another table that just simply allows me to display a
different name than what's in the main table. So if the
name in the main table is "Direct Call", the additional
table "sees" "Direct Call" and puts my name for it (From
Client) in the query.

Okay, I have two fields in the main table that can use
this other table. Do I point both fields to the other
table, or do I bring in two copies of the other table, one
for each field? Or What?

tod
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top