>
>Chu, there are 2 ways to handle this.
>
>1. Populate your grid with a View instead of a cursor. The view has Product_name as one of its fields.
>
>2. Set a relation between tables B and C. Then in the grid set the column controlsource to C.product_name. Although you can't do this in the builder, it is perfectly OK to use a field from a related table in a grid column.
>
>HTH
>Barbara

Barbara,

Thanks for your reply. I tried the second way and it works. However, I encounter another problem. When I run the form, all the rows in the grid show the same content. The same happens to my text box (not in the grid) which is the content from C according to the content in B. They work fine once I click on them or move to another record. Did I do something wrong?


Chu