>Christian,
>As Bill said, you can't use parentheses () in an index name. You also need to be careful not to use reserved words like "deleted" or "Desc" in your field and index names. You can get some weird results when VFP is confused about whether you mean a field named "DESC" or want to order a cursor "Descending". The same is true with "DELETE" and "DELETED". Bill uses "Deletes" and I use "DELTED", both different from any reserved word.
>
>HTH
>Barbara
>
>>Hello,
>>
>>I want to set indexes programmatically.
>>How do I set an index on DELETED()?
>>
>>I try INDEX ON Deleted() TAG Deleted().
>>
>>It won't accept this tagname, but in Modify Structure I can use the tag name Deleted(). Should I leave the () away or is there another way?
>>
>>Thanks for your help.

And a caviat recently found. If you have index tags on deleted() on your tables, Access has trouble dealing with the tables (sometimes). We have such a tag on EVERY table in our product, and access has a problem with about 1 table in 7. Go figure, you would think it would have a problem all the time, or never, but not Access. Just part of the time. I have also seen some benchmarks in either Foxpro Advisor or Foxtalk (can't remember which right now) that imply that having a tag on deleted() may actually slow queries down unless you have a LOT of deleted records in your data all the time.