Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Advice on Data Manipulation
I've created a form that uses a view in the D.E. made up of 3 tables: inventory, customers, and transactn. On the form is a dropdown linked to a field in the view called Stocknum, which is the primary from the inventory table.
In the interactivechange event of the dropdown is a procedure that finds the record in the view with the value selected in the dropdown. The appropriate data from that record is then output to other objects on the form.
I want to add a new record to the inventory table. Since the view is made up of fields from 3 tables, and I want to append to only one...
1. do I need to close the view and open the inventory table in order to append? How would you best do this?
2. What effect would appending to the view have, since only data for the inventory table would be entered?
Thanks
JD
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