>BTW with 800-2000 recs 'speed is reasonable' - if you mean it's noticable but acceptable then actually you should investigate bottlenecks in app.
>Cetin
Thanks for the info, Cetin. I'll check into the Set Key idea.
As for bottlenecks, I'm not real sure where to look. Imagine a form, showing some basic fields and a basic toolbar that moves the record pointer forward or backwards. The form is bound to a single table. The data is filtered (based on the teacher code). At some schools, the time it takes to go from one student to the next is not very fast (a second or two) but at most it's instantaneous. How could I improve the speed is the basic problem (which is why I asked about views.) I truly feel that at some of the schools the network is a bit slow.