>Good afternoon Cetin:
>
>Tried your new suggestion, still not displaying what I want.
>
>select gidetail.sin, client.surname,client.firstname, client.phone1;
> from gidetail, client;
> where gidetail.sin = client.sin;
> and gisum.sessionkey = gidetail.sessionkey;
> into cursor aclient nofilter
> index on sin tag sin
> select gidetail
> set relation to sin into aclient
> with thisform.grid1.Columns(2) && Recordsource = gidetail ?
> .controlsource = "aClient.surname"
> .readonly = .t.
> endwith
>I put this in the init of form A (forma appends blank record
>in gidetail and calls form b for input)
>
>My grid on form A has these properties set:
>childorder - sessionkey
>link master - gisum
>recordsource -gidetail
>relationalexp - gisum.sessionkey
>
>Column 1 -gidetail.sin and column 2 - gidetail.result
>Column 2,3,4 - these are where I want names and phone number.
>
>With this code I get sin in column 1 and sessionkey displaying in column2.
>
>I don't know why but this has been a nightmare to try and get working properly
>I really appreciate all your help.

---

Good morning Sheena :) Unfortunately I was blind to world yesterday.
Seems we are doing a simple thing in a complex way :)
-Client table connected to gidetail by "sin"
-Client table has nothing to do with sessionkey, right ?
-Client table serves just as a lookup for surname, phone etc.
One confusing thing :
Column2 - Gidetail.result and at the same time surname ?

Add client table in DE too with order tag "sin".
In DE set relation from gidetail into client on sin.
Build your grid with properties you say with 5 columns.
Starting with column 2 (3 ?) set controlsources as :
"client.surname","client.firstname", "client.phone1".
Set those 3 columns to RO.
That should do it. But being honest above method also works AFAIK.
Cetin