>>>>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,
>
>first table -- teacher name, code for position
>second table - code for position
>third table -- code for position, position description
>
>if teacher can have more than one position (2nd becomes teacher code, position code) i can understand, but that isn't clear from the original info given...


Thanks for responding,

First table = teacher_id, teacher name
Second table = teacher_id, teacher positions code <-(GRID) column 1
Third Table = code, description <-(GRID) column 2

It is important that in the third table that it is a generic code
it is used for many other descriptions as well as this teacher position code


Am i wrong in assurting that a grid can handle only 1 view,cursor,table
at a time ?

Thanks again for you help