>I got a problem with my database when I create a routine to create its table's indexes with first
>delete tag all
>and then
>alter its primary and foreign key with index tag
>its works fine but when I open its database designer .. I got surprise that its persistense relationship rule change with all Ignore. Is there any way to safe my all rules setting while reindexes.

Zubair --

You might want to download the Database Index Recovery Tool (DIRT) from the Files/Classes area of this forum. Whether or not you actually use the utility, the code will show you some ways to recreate VFP indexes.

Bill