John,
Reverse the order of the filters so that the parameterized filter is *last*. This should correct the situation (at least it did in the test I just ran <g>).
>i have set up a view that display's all the data fine
>if I only use one filter if i use a second filter to hone in
>on only the records I want one of two things happen it displays
>everything or nothing. is this a problem with the view or am I
>using the filter wrong in the view. this is the filter it works
>fine if I just leave the first line in.
>WHERE Estdtail.estimate = ?pcParam;
> AND Estdtail.material = "view_estimate_mat.matd_id"
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?