Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement