Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Without looking at your View in the Designer of course it is hard to tell what the problem is, but you should check to be sure that the fields that are to be updated are checked in the "Update Criteria" tab of the designer. To do this you must have a key selected (this of course needs to be unique) and then you can select the "Update All" button to select all fields. You nay select the key and the fields to update by mouse clicking next to the field name in the selection box, clicking directly under the Key symbol marks the key. Note that "Update All" does not mark the Key field updateable. You may select to update the key as well (if say your key is a client number, and may change). Realize that you need to be careful with the referential integrity of the joins, that is, if you change the ID in the parent table and this is a ID used for a join it must also update in all child tables as well.
On the second problem, first be sure that all the fields you need are coming up in the view (In the view designer, click on the area behind where the tables show up, then select "Run Query"). If you are modifying the original form then you will need to change all the ControllSource property for each bound control (Text Box Etc.) so that it points to the View, not the original table (VIEWNAME.FIELDNAME not TABLENAME.FIELDNAME). I would also remove the original table from the data environment of the form (right click on the form in, then select Data Environment, right click on table in the data environment and then select Remove). This is just to make the form run cleaner.
See if this helps and let me know.
John
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