>I had set a filter in the remote views for the related table IE. twnnme=afs.cityphys. When I scroll thru the records it is not refreshed. I have 1700 records in the primary table that I am starting with. I will have to study on how to change to parameterized views.

You mean you're using SET FILTER TO command?

This might help point you in the right direction....

http://www.dfpug.de/loseblattsammlung/migration/demos/remviews.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dgoptimizing_access_to_remote_data.asp

http://docs.rinet.ru/GlyadiLisu/ch08/ch08.htm