Ian,
I don't have any practical experience with SET KEY. Once I found the problem with a filtered grid back in VFP3 I switched to using the LinkMaster, RelationalExpr and ChildOrder grid properties. I did two production apps and just ran into too many other headaches, so I've been using p-views for the last 4 apps.
So SET KEY may get this app out the door quicker for you and it works. I'd recommend using p-views on the next app though.
>I noticed SET KEY in the suggestions below and did some research/testing on it. It appears to function quite well. Do you beleive that SET KEY is a more efficient/faster way of connecting tables than SET FILTER???
>
>NOTE: I have decided that I have too much time already invested (one month of a two month project) in my current code to start again (which I would have to do if I changed my logic to VIEWs rather than the current FILTER {or possibly SET KEY} system.)