Trying to speed up a report

[pokerace]

C10
Access
Interbase

I am using one table in access, and multiple tables from an Interbase database. The access table is linked via inner join to an Interbase table by SSN. If I place one field from the Access table and one field from the linked Interbase tbale, the report runs quickly.

However, when I link the first interbase table to a second interbase table via common field IDs and then insert a field from that third table into the report, it begins to slow down considerably. I can't link the Access table directly to the second Interbase table because there is no common field.

Here is the current linking structure.
AccessTable(SSN)-->innerjoin-->InterbaseTable(SSN)-->innerjoinInterbaseTable2(ID)

Any ideas on how to get the report to run faster while still allowing me to link the three tables together?

 

[Madawc]

If you can use SQL and Stored Procedures, that would speed things up a lot.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[trinzul]

Do you have the columns in your query indexed?