Hi, Wei.
Establish a relation between the detail table and a lookup on DetailTableKey.
Set the ControlSource for the column in your grid to "Lookup.Description"
Kamil
>I have two tables in a 1-to-many relation, and a form to edit these two tables. On the form, the master table record is displayed in the fields, and the detail's are displayed in a grid. The detail table has only three fields:
>MasterTableKey, DetailTableKey, Quantity. There is a lookup table that contains the description for each DetailTableKey.
>
>What I want: I do not want to display key in the grid. Instead I want to have a description for the DetailTableKey item showed in the grid. In other words, I want the grid to show ItemDescription, Quantity, while the ItemDescription is in a lookup table. The user should be able to enter/edit the record of the detail table in the grid. The 1-to-many relation needs to be reflected on the form, i.e. move the master record, the grid will be updated.
>
>Question: How can I do that?
>
>Thanks.
>
>WL
A moment of silence is our cosmic reset button.