tough SQL query with secondary data sources

[RickH]

Problem: I need to list all the routes associated with a certain ship, along
with their name, code and description.
I think that using a drop down listbox bound to the Query:RoutID field is
the way to go.
However, I can't get a full list of all the routes (as defined by entries in
the RouteAssoc table) to be returned by the query. (I can get one route
returned, not all so far).
Is this possible?

SQL table list

Route table
RoutID pk
RouteCode
RouteName
RouteDescription

RouteAssoc table
RouteAssocID pk
ShipCode
RoutID

Ships table
ShipCode pk
ShipName