Hi Dennis,
I have not done anything in VFP9, but in VFP8 and VFP6, I have grids that show fields from two related tables correctly. I use the native DE and in the DE I set a relation between the the two tables. The data shows up correctly from there, without doing anything else. This must be a problem with VFP9.

>James,
>
>So anybody else in this VFP universe who has done anything else to circumvent this issue? =)
>
>Thanks,
>Dennis
>
>
>>Dennis --
>>
>>Yes, that's exactly what I've done. Inelegant at best.
>>
>>But is this a bug? That's hard to say, because I don't know what else is going on. In any case, I've always wondered by refresh didn't do the trick.
>>
>>Jim
>>
>>>James,
>>>
>>>Hi. This has also been my experience. What I do is everytime the form the grid is in has been Activate(d). I put code in the form's Activate event to setfocus to the grid. Not elegant to say the least.
>>>
>>>How do you tackle this problem? Is this a bug?
>>>
>>>
>>>>It's been my experience that this works as long as the grid has the focus. If not, it may happen that the fields from tables other than the grid's recordsource may not display properly. (And the user can correct this by setting the focus on the grid.)
>>>>
>>>
>>>Thanks,
>>>
>>>Dennis