Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
PROBLEM: impossible to use lookup relations on grid
Message
 
 
À
17/09/2003 12:24:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00829957
Message ID:
00830185
Vues:
19
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.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform