Hi 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