Hi Walter

I hope the bold text in your last reply wasn't representative of anger.

If you're using a SQL Server backend, you don't get direct access to the tables. So the alternative viable approach you refer to doesn't exist in a C/S environment (except that one could write stored procedures).

I like the KISS principle and having to re-examine both approaches for every situation is obviously not keeping things simple.

The set filter command filters tables. So why do other commands support filters too? That makes VFP much more complicated. That tendency has good and bad points.

Why not just...

SET FILTER TO somecondition
BROWSE


instead of


BROWSE FOR somecondition


Is there really any great improvment by this? Both techniques are valid, but only one technique is essential.

You often use the term revert to intelligent keys. Revert implies going backwards.