>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.

Can you describe the sub groups? Is it possible to have many parameters in your view that will be stored? for each user and queried on the init of the form?