This will work if you don't bind the Grid to a RecordSource. Just specify each Column's Controlsource as needed to a specified Table.Fieldname.

I do the details in Code but maybe there's a design alternative also.

HTH,

-Irv.


>I have a grid with Grid1.RecordSource = "Table1" Then I have each Grid1.Column1.Text1 = Table1.field1 and Grid1.Column2.Text1 = Table1.field2 and so on...but I want a column's text to display fieldn from a related table. That is, right before loading the grid I setup the two tables with a relations command: SELECT Table1 SET RELATION TO fieldn INTO Table2 ADDITIVE
>This relation works great for my report, just not in the form. My ControlSource for the Grid1.Columnn.Text1 for this related table just has "table2.fieldname".
>
>References in a report will pull in the related table but not on the form for some reason.
>
>Is that clearer?
>
>Doug