I have it set to retrieve all records, the assorted requeires are only to enforce filters as VFP will not reqocnise keys in remote views. All views were written with the default view tool and are of the select table_name.* from table_name format. As the view query is read only, how would I change it to read each field name? I am almost ready to rewrite the whole &*%^$# thing using SQL passthrough, but I am on a very short deadline.