Tom
|
| Posted: 08/24/2002, 9:22 PM |
|
In CC, when you defined a label, there was a join tab that allowed you to translate the value retrieved from the database field into a more descriptive text. You could give a list of values ( 1;Red;2;Blue;3;White) or give a sql statement showing a lookup table.
In CCS, is there a obvious way to do this? I've written code using DLookup in the before show row to change the label value but that seems overburdensome.
How are others doing this?
Thanks in advance
|
|
|
 |
Nicole
|
| Posted: 08/27/2002, 4:09 AM |
|
Tom,
In case the reference data is stored in the table you should build sql query that select all the necessary fields from two tables. Ones you’re using list of values the valid solution is to replace field vales in before show row event.
|
|
|
 |
|