Rod,

Edward has been very thorough in telling you how to create your index, but if you are using this view ONLY for reports you have other options.

1. Use a cursor instead. This saves space in your DBC, and can also be indexed.

2. Add the fields you are linking via your "Set Relation" code into the cursor/view. This way you have no need for the index at all.

Of course, I don't know all the details of your application, so you may have thought of these and discarded them for good reasons already :-)

Barbara

>Is it possible to index a view. I have crated a view, brought it into the report designer. I want to set a relation from a field from another table in the report that would drive a key field in the view. The view designer lets me set an order, but when I try to drag the relation line in the designer, I find there is no index in the view I created. I am new at this, so forgive me if this is really stupid.