The DBMS language I had used for DOS had a limitation on the number of indexes we could have so I am very accustomed to making compound indexes involving many fields.

As I am becoming more familiar with the way VFP and Rushmore works I am beginning to wonder if it isn't better to create most of my indexes based on one field.

The only down side I see to doing this is that I wouldn't be able to use seek statements if my search criteria involves more than one field. But then I guess I could use a locate for with multiple indexes.

I know there would be exceptions to the rules where I would want more than one field in an index...But, I am just curious on how some of you set up your indexes.

Thanks for your time,
Paul