Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
2 Tables, One Form
Message
De
27/05/1999 15:08:17
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00223537
Message ID:
00223635
Vues:
22
I don't know how your form is set up. The way I normally build a parent-child form is by placing the parent control on the form and adding a read-only grid for the child. I would add 3 command button: Add, Modify and Delete. The first two buttons would display a modal form to add all the information about the child.

In the Save method of the child form, I would issue a INSERT-SQL to the child table if the Add button was selected in the parent table.

In the Save method of the parent form, I would put a TableUpdate() for the parent table and a second one for the child table. TableRevert() for the Cancel method.

Naturally, this require a record/table buffering for the parent table and table buffering for the child table.

HTH

>Thanks for your reply!:) I really needed someone to verify my fears...ok, I see what you are saying, can you give an example, or suggestion on how to do this?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform