You You must INDEX CA in each form where You use it. But You can just put the index in AfterCursorFill() event of the CA. I don't think indexing of the CA will cause some troubles if You change server, project folder or switch to other DB.

>hi
>
>Thank you for kind help,it is working fine, but now i have one more doubt, for each form
>i have to create seperate index for each cursors? there is no other option like VFP create
>once in a table and set to index order?. if i change my project from one pc to onother pc
>or Switch to another Databse or Cahnge Server this dataenvironment will create any probs? like vfp database if change the project directory dataenvironment serches for databse and default paths.
>
>Once again thanks a lot
>
>With thanks and regards
>Abdulla