I had ask this question before but im still in the dark as for the solution.

I have three tables

1) teacher table
teacher id
teacher name
2) teacher jobs
teacher id
teacher job
3) general code descriptions
code
code description

table 1) is the master
table 2) is the detail and its a grid
table 3) has descriptions to all kinds of codes

a single teacher may have many jobs

the grid has 2 columns

column 1) jobs code taken from table 2
column 2) jobs code description taken from table 3)
and this column is for display purpose only


this is how i want it to look


teacher id: 2447
teacher name: Flinstone, Fred


-----------------------------
|jobs description |
-----------------------------
|02 grade 1 |
|03 grade 2 |
|99 vice principal |
| |
-----------------------------

now i have the first column showing without a problem
but the description column is always '0' how do i output
that description information.


Can i have a master detail relationship with a view
i don't think so.
page 201 of chapter 8 of the Developers Guide says i can't
am i reading it wrong?

I know in Oracle you have a postupdate trigger that fires
and updates a particular row depending on the job i am
displaying / updating.

So the question is this HOW CAN I DO THIS IN VISUAL FOXPRO


thanks in advance.