> > Robert, > > Thanks for the info. Did you use a remote view in VFP? Once you could see > the tables, how did you access them? I guess I have a lot of questions > about this. Anyway, I'll have more when I start trying it. > > Jim Yes I did use remote views, as well as individual table excerpts. The peculiarity of the final two projects that I worked on lied in the fact that the data was supposed to be accessed through my interface as well as AS/400-terminal-based interface that was written in COBOL. I ended up having to remove some triggers and stored procedures that I had created to ease the coding stage, and had to increase the number of SELECTs in my code. Should it have not been for the necessity to keep the COBOL application operable, - I would have written all the data massaging routines in stored procedures...Oh well, it's not "my baby" any more :( Now I am writing a VB system with multi-database-brand support (AS/400, VAX Oracle, Sybase SQL Server, MS SQL Server...so far), but the concept remains the same, which is good news :) ...did mention VB ??? (Duck!)