Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can a grid show fields from two related tables correctly
Message
De
31/07/2006 15:36:16
 
 
À
31/07/2006 02:33:18
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01141727
Message ID:
01141911
Vues:
18
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.)

>>A grid shows fields that are stored in two related tables. At the moment I am creating a cursor with the combined fields and use that as recordsource of grid. If user changes the relating field in the grid, I need to show updated values in grid. One way is to recreate the combined cursor, but is there a way to make a grid show fields from two related tables without creating a combined cursor so that values in grid are automatically refreshed in the case described?
>>
>>TIA,
>>
>>Alex
>
>Simply set the controlsource of the editboxes accordingly.
>Yourgrid.column1.text1.controlsource='table1.field1'
>Yourgrid.column2.text1.controlsource='table2.field1'
>I also set the columns' controlsource to the same value, but I don't know if that's important. But as always, better safe than sorry. :-)
Jim Nelson
Newbury Park, CA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform