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.