>As I understand it, the 'Index on deleted() tag anyname' is used by Rushmore to reduce referencing the DBF itself when the 'SET DELETED ON' implied filter is set. The name of the tag does not matter, it is the 'DELETED()' expression that is important. Second, Rushmore ignores any conditional indices, i.e. 'FOR...' on the index command turns off Rushmore's use of the tag.

Ok,
my need of the tag has to do with the SET DELETED ON environment rather than the FOR clause. SYS(3054) shows the queries to be optimized with the extra DELETED() tag and only partially optimized without it.

I could change the VFP code to work with SET DELETED OFF and get rid of the tag, but I'm hoping there is another way to make the Access connection.

David,