>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.
>
>Thanks in Advance,
>Sandi
Can you base the grid recordsource to an alias? If so, just do a join of the two tables into a named cursor and assign that to the recordsource of the grid. Something like
Select tbl1.code, tbl2.description From tbl1 join tbl2 on tbl1.code=tbl2.code Into Cursor myCursor
HTH