Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Inserting record into tables via view
Hi
I got a table in which I add different types of products. All the products have several fields in common and some which are not. The fields which are not compatible between the products are stored in different tables. For each type of product there is a special form for adding, deleting and updating records.
My problem is as follows: in every form I use a view to show the records in a
grid ( I got to Do it this way as I got to select several records) this view is conformed by the two tables in which the data is scattered. So, my problem would be how I can add records to both tables through this view, whether when I insert a new record or decide to save The changes. Another problem that I got is that both tables got to be related by the field 'Key' which is added by user.
What is the best way to address this type of problem?
Thanks very much in advance
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