having to deal with massive query's

[quandore]

Hi again.
I've got a query of almost 2 million records and i want to perform a market analysis by adding a form which let me filter by Product Group (99 entries) and Discount Group (89 entries).
The problem i am encountering here is that, plain and simple, it takes ages to filter these fields. takes a lot even to switch from table view to design view or whatever you call it.
what i do is: building a form from the Product Group query; adding a subform from the 2-million-entries table.
i didn't do anything professional though. i think i am missing something here.
is there a well known way to make forms run faster when you have lots of records?

[orange]

Have you normalized your tables? Do you have meaningful indexes?

Here are some performance tips
http://www.fmsinc.com/tpapers/faster/