>The application opens.
>The user clicks on a button (which the programmer has designed)
>called Student Information
>This button open a table displaying four columns and several hundred records.
>The user chooses a particular record in order to see more information about
>that student.
>The user waits and waits and waits and waits (up to 15 seconds) for
>a related table to display more detailed information.

Ah...and you have an indexed key? If you're using a relation, try setting it off and just do a SEEK or LOCATE on the child/related table, see if that helps, if you haven't tried that yet.