Dear Mr. Obvious

Long time listener, first time caller.

My problems all started after prototyping a killer but relatively simple inventory app, when I was asked to finally connect to an IBM AS/400 Box and it's data contained there in.

First of all Mr. Obvious I'm not an AS/400 kind of a guy. I just need you to placed me on the right path to pursue this unknown.

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).

To let the DataEnvironment in a form do it seems even worse. What can I do or where can I go for answers?

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 !!!