Hi!
I developed a query which has several nested JOINs in it. Since I need a few fields to be variable, I just use (e.g.) date1 instead of an actual date like "10/20/2008". So, when I run the query, I get a pop-up asking for a value for date1. In my query I have three of these variables, which are used in each nested JOIN (meaning that each nested JOIN is a nested query which also uses these variables).
It works fine.
My idea was (is) to use a form and combos or lists to select dates and the rest of the variables, then apply the filter with these variables.
What I found is that (apparently) the form first does a huge cartesian product and then will apply the filter. Is this correct? (I actually never got to the end since it aborts...)
If this is so, I suppose a workaround would be to include the sql statement in the form instead of using filters.
Any ideas, comments?
Thanks a lot.
Gerry
I developed a query which has several nested JOINs in it. Since I need a few fields to be variable, I just use (e.g.) date1 instead of an actual date like "10/20/2008". So, when I run the query, I get a pop-up asking for a value for date1. In my query I have three of these variables, which are used in each nested JOIN (meaning that each nested JOIN is a nested query which also uses these variables).
It works fine.
My idea was (is) to use a form and combos or lists to select dates and the rest of the variables, then apply the filter with these variables.
What I found is that (apparently) the form first does a huge cartesian product and then will apply the filter. Is this correct? (I actually never got to the end since it aborts...)
If this is so, I suppose a workaround would be to include the sql statement in the form instead of using filters.
Any ideas, comments?
Thanks a lot.
Gerry
