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