Ok, lets see if I understand indexing in foxpro:
If I have a contact table and I want to benefit from rushmore I need to create an index in the table for every field that might be used in a quary including an index on the deleted records.
If I am using a view to load a form and I want to have control over field order I need to create an index on the fields in the view
The index on the table has no benefit to me while using he view.
Dennis Collins
TRACKUM, Inc.