Gary D
|
| Posted: 08/07/2002, 3:57 PM |
|
I'm stuck with a old database that uses lookup tables. The problem I have is this: If a record returns "ACE" you need the lookup table to translate it.
A = red
B = Blue
C = Green
D = White
e = Black
So I need to display: "Red, Green, Black"
any ideas??
I'm using Studio and asp
Thanks in advance!!
|
|
|
 |
Ron
|
| Posted: 08/08/2002, 5:16 AM |
|
Gary,
CCS doesn't include look up functionality for Label and URL fields as CC does.
You should build sql using visual query builder that will selected all the fields from all the tables to be displayed on the forms and used in Where clause.
|
|
|
|
|
