Quite true, Victor, but the original code uses 'SEEK' on tables that are now 700K+ records. Sure aren't going to do a view for all the records and then index it :-). We've changed to parameterized views, and the users just have to learn that they can't skip from one record to the next for 700,000 records.


>In VFE 6 you can index your views.
>
>Regards