>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"
Not sure I understood your question. But if you want to be able to gain more granularity, why not use more parameters and do a requery() after. Say you have 2 parameters and the user leaves the second field blank, you'll just retrieve all records that match the first condition.
José