Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parent/child form with a grid and next/prev buttons
Message
De
31/07/2001 17:04:09
Larry Huisingh
Lockheed Martin Information Technology
Richland, Washington, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00537917
Message ID:
00538024
Vues:
12
>>I have a form that I want to use to display a parent/child relationship. The child table has 2 fields displayed in a grid. I have a container class with next/prev buttons. The "next" button contains "skip 1" and "Thisform.Refresh()". I have discovered that I am missing something. If the child table has more than 1 record for the corresponding parent record I have to press the "next" button once for each child record to get to the next parent record. It seems like the button is switching the alias to the parent table prior to issuing the skip 1 command. I know the button code is primitive and needs more code but what code would allow me to operate on the parent table records?
>
>In your buttons code you should explicitly select the parent table before doing any operations.

It turns out I had the data environment relation's OneToMany property set to true (similar to the SET SKIP command). I didn't understand this property's usage when I was just trying various things to get the form to work and that was one I set as I was blindly stumbling around. It goes to show you what trouble a relative newbie can get into if he/she starts changing properties willy nilly. I discovered this property even while Gerry Newton was writing his response to me that suggested this very solution.

Thanks for all of your patience.
Larry Huisingh
Lockheed Martin Information Technology
Richland WA USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform