The easiest way I would know to do it is to create a parameter on each of the fields possible. But, make them (where myfield like ?myvariable)

Then include (just before you requery() the view) code to replace all the variables with "%" if they are empty.

>In the intrest of speed, I would like to load a form that uses remote data with NoDataOnLoad = .T. for the six editable tables in the form (4x 1:1, 2X 1:m) While it is easy to modify the view at the DBC level to a parameterised ( WHERE parent.id_num = ?c_id ) view and pass the same var (c_id) to the dependant tables, I have found no way, at design time, to detemine if my users want (WHERE parent.dept_id = ?c_deptid) or any of several other valid selections. That said, as I start to add user groups, some will have pr-defined WHERE 's, mostly on Dept_id, plus the option to select a sub-group from that. I have the template form writtten and debugged(finaly) and now need to generate the custom versions for the user groups.
>Any suggestions, or just let the userstwiddle thier thumbs while 10,000 records load from the server? ( 6 minites on my P400 with 128 mb ram. My users have P166 with 64 MB RAM)
>
>Thanks for any advice/help.