> I made a big mistake, I think I should have used local views to begin with. > Now I need to upsize my application to a SQL server. The upsize wizard > worked, converting all my local tables to remote views. But now NONE of my > forms work! For most of the forms, I was using a SEEK to find a selected > record and display it. > > How do I do the same thing with views without indexes? use parameterized views - (and check the NoDataOnLoad property in the DE) then after you have a critiria just requery the view Arnon