A join query is a query that joins related tables together.
Since you used access for generating the screen shot, you should be able to use the access query builder to generate the join query for you.
when you select a trial, pass the trial ID to the results page.
the record set would need to join the TrialsT, TrialsCatalogT, TrialCompetitorsT, and DogsDetailsT and filter on the trialID passed in using the TrialsT.TrialID column.
using the join query will allow you to return the related information for the selected Trial from the DogsDetailsT table.
morte details on join queries can be found here:
sql_join_inner.asp