Query Optimization

[kedarj]

Hi,
I have following tables:
Employee Master : Employee_ID, Employee_Name
Employee Specialization: Employee_ID, Employee_Specialization
User selects Employee_Name from Employee Master.
User then has to select Employee_Specialization from a combo Box (This should contain all Distinct Employee_Specialization for the Selected Employee)
I have 65000 Records in the table.
When The user clicks on combo of Employee_specialization, the query takes a long long time to load the distinct list of Employee_Specialization.
can anyone suggest, how I can optimize this?
Regards
K

 

[Ron_dK]

In your table, ensure that the relevant fields are indexed.
You can set that property in the table design mode.

 

[Pat Hartman]

Why not define Employee_Specialization in its own table. That way your combo would use a lookup table as its RowSource rather than having to summarize away thousands of rows.