Not sure if you'll recieve this but I am still having the problem. I had got rid of it when I was using a VFP database but now I am using a SQL Server database with the FoxPro frontend.

The way I got rid of it in FoxPro was in the BeforeOpenTables event of the data environment I created the working table.

select loaddetail.* from loaddetail into table wkLoadDetail
index on alltrim(str(wkLoadDetail.loadnum)) + wkLoadDetail.salesnum tag loadsales

But I can't do this with the remote view of loaddetail in the one with the SQL Server database.

Any help would be greatly appreciated.

Tyler