Fabio,
>i use a relation for lookup text values on a cursor and put text on a grid.
Grids are just not designed to work with two cursors as you are trying to do.
>
> ADD OBJECT grid1 AS grid WITH ;
> RecordSource = "CA", ;
> Column1.ControlSource = "CA.id", ;
> Column2.ControlSource = "CB.Txt", ;
>
> than is hard to found a workaroud.
There are several ways to solve your problem.
1) pull down a denormalized cursor that contains your looked up value.
2) run a SELECT once the data is in VFP to a denormalized cursor
3) put your lookup data into an array property of a combobox, that is bound to the PK value from CA and use that as the control in the second column of the grid.