>I would like to know how u can use more than one table in a grid. I have a grid with the following details from a single table: prod_code, qty_cost. I want to display the prod description in the grid as well. But as the prod descriptionis from another table, I need to change the main table I use on the grid. When I do this I loose the other fields. Is it possible to use more than one table on a grid? IF so, how do I do this? I just need the description field as a read only field, so that is displays once the prod code has been entered on the grid.
>
>Thanx
>
>Stuart
Stuart,
There are multiple ways. One I find easy and doesn't need any relation is :
-Add a column to your grid to hold description field
-In column.controlsource enter expression like :
(iif(seek(mytable.myKey,'OtherTable','IndexTag'),OtherTable.Description,''))
Cetin