>>THE QUESTION:
>>
>>How does one show the description in the second column
>>based on the first column in the grid.
>
>you can set up a local view consisting of the 2nd table code, 3rd table description.
This is correct.
>why do you have the descriptions in a third table? (just curious)
I think it's called 'normalization'. Don't ask me, I break this rule all the time! :)
Regards,
alistair israel
Distressed DBA, Sleepy SysAd, Weary WebMaster (aka Senior Software Engineer)
aisrael@poboxes.com
Makati City, Philippines