>Thanks Edward,
>
>Tried to index view but was unsuccessful, will try again. The idea I guess is to try to makeit easy on myself while designing the app and also making it easy for an end user to create a few of their own reports, with minimal understanding of the DB schema and SQL, etc.
>
>Don
View designer will fail when you will try to create complicated SQL, it's limited tool.
To get view indexed you should set Buffering=3 (using CURSORSETPROP).
Edward Pikman
Independent Consultant