General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
For a view on a view i think you need to first refresh the parent view and then the child view if you hanged something in the data
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only