>It was horrible, when I finally created a local view from (2) remote views one to join the AS/400 data to my apps MS-SQL Server Data, things got ugly. It took forever (over 4 Mins) to open and BROWSE the table data (28,000 records).
>
You have to stop thinking tables and start thinking SETS. Why did you bring 28,000 records accross the wire? Did you need all those records? When you create a maintenance form you have to find a way to limit the amount of records you need. Ask your users what item the want to work with, or what category.
If you want to build a pick list, ask them for the first few letters of the Description or part number... Then, just get the records that match that, and work on that small data set.
If you need to process LARGE files from top down try to do it on the server with a stored procedure.
>To let the DataEnvironment in a form do it seems even worse. What can I do or where can I go for answers?
Look at any book on building client server applications. Try
www.redware.com for a VFP specific book.
>I'm using the IBM Client Access ODBC driver, I'm told. I've read some VFP help files but still feel void of information.
>PLease Help Me !!!
HTH,
BOb