>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.
You may index a view the same way as table:
Select MyView
=cursorsetprop("buffering",3) && if it's not 3 yet
Index On myfield Tag myfield
Now you may use SET RELATION
Edward Pikman
Independent Consultant