Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Display order of child records in Grid (VFP 3.0 for Win)
Message
De
25/07/1997 19:36:27
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00041728
Message ID:
00041750
Vues:
41
>>>How do I set the order of display for child records in a grid on a 1 to many form? Note: I am not using the data environment.
>>
>>In your relational key, just add the secondary key for the sort order.
>
>Michel,
>
>Could you be a little more clear? My tables are... The indexes on the fields have the same names as the fields themselves.
>
>DEMOGRPH (parent indexed on ID and also indexed on NAME)
> ID
> NAME
>
>LABTEST (child indexed on ID and also indexed on TESTNAME)
> ID
> TESTNAME
>
>I would like to display the child records ordered by testname.
>
>GRID PROPERTIES
>Child order: id
>Link master: demogrph
>Record Source: labtest
>RelationalExpr: id

You mentioned you wanted the child grid to be in a specific order.

If you have a child grid, this mean you have a parent field in it which is linked to the unique id of the parent table. By looking at your details, I would say that you can change the tag expression of id to be id+testname. The relation will still work and will be ordered. Howerver, you might want to do some translation in the expression in the case where id is numeric.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform