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?

My main add/update screen takes a while to load now because the view download all 4,000 records. How do I speed this up and still give the user access to all records?

Any advice?

TIA!

Jeff