I think you may have hit the solution. I'll experiment with it.

You may be assuming that I know more than I do. I've been working with VFP for only about 6 months, and am still trying to figure out the details of it. (Especially comboboxes.)

Docs and books only seem to describe the obvious usage of the controls, with little info on how to use the features to make them do what you want them to.
Thanks for being willing to assist.

Neil

--------------------------------------------------------


>>> When reviewing the order, the description field must be displayed from the products table based on the productid stored in the orderitems table. <<
>
>Forgive me if I seem dense, but I still fail to see what the problem is when using a RowSOurceType of 3-SQL Statement. If your select from the products table contains the PK for the product (I am assuming that the productid is the PK)in, say column #2, you just make column 2 the combo's BoundColumn. If it is a numeric value, you set the combo's BoundTo property = .T. The you set the combo's ControlSource to OrderItems.ProductID.
>
>As long as the product description is the first field in your select, it will be displayed in the text portion of the combo as well as column 1. If you do not want the productID visible, just set columnCount = 2 and ColumnWidths = something like 150,0 .
>
>Or am I missing something fundamental here?
>
>Marcia