Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to properly set up a view?
I need to use a view with a lot of tables. For various reason but mostly
because relations are needed to be displayed in a grid, which at least in
vfp5 doesn't work well. I'll simplify for my example.
parent child
---------------------
Order orderdet
orderdet prodcode
orderdet prodname
orderdet prodtype
Here's what I have done...
View1 -> order
view2 -> orderdet, prodcode, prodname, prodtype
Then view1 relates to view2.
But I'm wondering if the view should be...
view1 -> order, orderdet, prodcode, prodname, prodtype
...and do away with the relation.
I will be appending records to the view and updating the tables.
Which is the better way to do it?
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