I have a question on creating a grid with a combo box inside. My problem
is as follows (simplified version).

I have 3 tables - A, B, and C. A is the parent table with a unique id and
customer_name. B is the child table with two fields, unique_id and
product_code. C is a dictionary with two fields, product_code and
product_description. A and B have a one-to-many relation.

I created a form that shows customer_name from A. I also created a "one-
column-grid" with a combo box as the control with B as the child. When
users click on the combo box, product_name and product_id (from table C)
will be shown. Once the users choose the product, the assoicated
product_code will bound to table B.

My problem is that since B is the child and B only has product_id but not
product_name, I can only get the product_code shown on the grid, but not the
product_name. Product_name only pops up when I click on the combo box.
After I select the product, the only thing shows on the grid is product_code.
Do anyone know how I can get the product_name shown on the grid instead of
the product_code?

Thanks in advance.


Chu