>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.
Look at QBF Builder from
www.classycomponents.com. It will let your users do just about any kind of query they want.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer