>Thanks.
>
>BTW, do you know if this can be done at design time using Stonefield's database toolkit?

Indexes on views are temporary and can only be created at run time after the view is opened. Just do it in the init of the form.