Hi Daniel,

Sorry for jumping in. We do have indexes and the table we are looking at is an attendance table table which is huge. So I was thinking whether we can have a view for the active attendance records for the year and use a VFP remote view with parameters to look at those the user interested.

What is your opinion?

Thanks in advance.

Regards.

>What indexes do you have on the table? Indexes are the single best way to increase performance.