Naomi,
Thanks for your reply. Actually I am not using VFP tables in this one. I am using remote views on SQLServer and Postgres. It seemed like a good idea when I started but has turned into a nightmare. I think I am going to switch and use SQL Passthrough.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!