Assuming, that there is relation between table1 and table2:
Grid.Column1.Controlsource="Table1.Field1"
Grid.Column2.Controlsource="Table2.Field2"
I hope you've read this whole thread and understand all underlying problems.

>Hmm, I'd be interested in seeing this (w/o using a view or a query or a cursor).
>
>Can anyone give me details on how to get a grid to display information from multiple tables just by using a relation?
>
>Take care,
>Joe
>
>>>I'm just curious...with this technique of setting relations, can you use this in a grid? I haven't ever used more than one table in a grid...
>>
>>Yeah, you can. I'm a little fuzzy on the details, since I only saw it and haven't tried it, but I know it can be done.
>>
>>The example he did was a detail list for an invoice. Instead of the part number that was part of the detail table, he had it put the description from the parts table. And if you changed the description, it actually wrote the corresponding part number into the detail table.