Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Views created on other views
I have a view that is based on a number of tables. (It is a detailed view). I also have another view that is based on the first view. (It is a summary view). The detail view contains a field that I filter on. When I requery the summary view it is not filtering the data.
Originally, I tried setting the detail view as a parameterized view, but couldn't get it to work within my form. I even tried to 'hardcode' the parameter in my program, but it is a date and before the form loads I get a Enter Parameter dialog box, even though I have told the form to not load the data on opening the view. I gave up on the parameter and thought this would work as well, but it doesn't seem to look at the filtered detail view and use it to form the summary view. Is this a 'known' rule about views and filters, or am I missing something?
Thanks in Advance
Sandi.
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