Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
One - many layout ??s
Message
De
07/01/1999 18:27:17
 
 
À
07/01/1999 13:47:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00173318
Message ID:
00173850
Vues:
31
[snip]

As Barbara mentioned, you have a good start for the layout and her ideas were the same I would have suggested.

>What construct would you suggest to accomplish the 'double click' taking you to correct item?
>
The DblClick code will have to go in the current control in the grid's column - another good reason to have minimal child info in the grid.
You could either do something like:
thisform.pageframe.ActivePage = 2 && child page order number
thisform.pageframe.pagChild.txtCorrectControl.SetFocus() && specifically name the control

Or loop through the controls on the child page to find the one with the same ControlSource as the grid.column.textbox then set focus that way. The first way is probably quicker, but the second is more generic.

>>Also, PLEASE use parameterized views not a filter to define your child records. >It's harder at the beginning, but MUCH simpler in the long run.
>
>So I would be scoping to control inclusion of just those child records which match my background primary key? So as I moved to another parent then I'd set new parameter and use new result cursor? Or would parameter have another scope or function that I'm not understanding?

The easy way to do this is to add the parameter to the child view as the alias.fieldname of the parent view's primary key,
The code would look something like this:

CREATE SQL VIEW v_Child AS ;
SELECT * FROM database!child ;
WHERE child.fkparent = ?v_Parent.pkParent

After you change records on your parent, simply REQUERY("v_child") and refresh the controls.
The view parameter will look for a variable called v_parent.pkparent.

HTH
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform