Two Views, no waiting. No, you don't need to change the control sources. Reports depend on how you set them up. You may only need one view, but you are running into issues with it. So, you're trading one set of problems for another. IMO, the problems you have to deal with are bigger.
>But if I do that - then I need two sets of views though right? One set of local views (for VFP tables) and one set of remote views (for SQL tables). Then on top of that I'd have to write some gizmo to deal with all the control sources of all the controls on my forms and reports because those would change as I'd be dealing with two sets of views. Using my approach it's the same view either way so all those problems don't exist. ....or am I misunderstanding something??
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer