I redid an existing form using a view to local (LAN) tables. The form uses 4 or 5 views all based on the serial number (C 8) of the parent record. Initial query openig the form and Requery is taking 5-6 secs on each view pulling data from tables with about 100,000 rows. I am surprised that it takes so long considering that there is an index on the field being used in the where clause. Have I overlooked something. Server is running Windows Server 2003 and there are only about 10 PCs on the network

Thanks.