Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
The controls on your form should be bound to the view fields. APPEND BLANK when inserting a new record and TableUpdate() or TableRevert() when you are done.
Like I said, if you need an updatable view, then you need to include the PK. Make sure that in the Update Criteria tab of the view designer you check the PK (the little key) and all fields that are updatable (the pencil). Don't forget to check the "Send SQL updates" also.
For fields that are not in the view, you can define a default value in the table designer.
HTH
>If I have a form from which I want to enter a new record in the parent and child tables, should the objects on the form have sources that are memory variables from like, scatter memvar blank, or should they be fields from the views, like append blank and then use the view.field? If I try to use view.fields, it seems there is a problem updating all the tables and it has to do with the primary field (I think).
Précédent
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