>>I think that sparse property should do this. Also, there is really another way to do this job:
>
>Sparse shows the boundcolumn, which is the surrogate key. I don't want to display the surrogate key.
>
>I want to change the key value, but display the discriptive value.

Currently, I use the next column to display the discriptive field. It's ControlSouce is bound to the surrogate key in the lookup view. I use the second view and set a relation to it to avoid having to requery every time the user changes the supervisor. I only requery after the user choses to do an update. The user can change many records before update.