Information générale
Catégorie:
Codage, syntaxe et commandes
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement