>Does anyone know how to build a field in a grid where there is no underlying field in a table? For example, if you had a Product Code field and wanted to show the product's description in the next column, but the grid's underlying table does not have a description field so the value must come from the product table. Since it is a grid, I will have many different product code/product description visible at once.
>

Take a look at mskb#Q138779.