Stuart

You can use more than one table.

You can either use RowSourceType of 4 (SQL Select) and pull data from both tables, or you could setup the relationship between the 2 tables, and then use the Parent table in the RowSource of the grid, and then, in the Column that you want your 2nd table/field, put the reference in there, the relationship will keep the rows up to date.

Kev
>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