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