Well, if you used my builder to create a classlib of CAs, you could add thjis feature quite easily to the CA baseclass in the VCX. Then all the CA subclasses would have the benefit of creating any indexes that you may have specified in this array using your coe in the AfterCursorFill. Heck, I might even incorporate this in my builder.

>Hi Tracy
>
>That was what I assumed would have to be done. I just wondered what others had done.
>
>Am I missing something or is this an overlooked feature of the cursoradapter class? It seems to me that it should have an array property of index tags and keys that should be created and managed automatically. Including deleting the index file when the cursor is closed.
>
>Simon
>
>>How about Creating the index in the AfterCursorFill event?
>>
>>>Hi
>>>
>>>I have been testing out the cursoradapter class and wondered what is the preferred method of handling indexes with these cursor. Since they are created without indexes I will need to create some indexex if I want to use Relations or do an incremental lookup etc. I am thinking that always creating and deleting these indexes may be a performance problem.
>>>
>>>At present my framework uses listboxes instead of grids and thus requires at least one index on the PK for each table.
>>>
>>>What are peoples thoughts and suggestions on the use of indexes with the cursoradapter class?
>>>
>>>Thanks
>>>Simon