Planes fly from airports in Europe to Hubs in US and on to final

destinations

Some airports only go to one hub others go to all.

Some Destinations are served by more than one hub

The Schedules are only for the Airport to Hub journey.



I have an Access database structured like this:

Table1: Airports

AirportID      Autonumber

Airport           Text



Table2:  Hubs

HubID          Autonumber

HubName     Text



Table3: SchedOUT

SceduleID    Autonumber

AirportID       Number

HubID           Number

DepartTime   Text

ArriveTime     Text



Table4: Destinations

ID               Autonumber

Destins      Text



Table4: Joiner

ID           Number

HubID    Number





What I need to do is produce lists by airport like this:

Airport 1

A list of Hubs that Airport1flies to

A list of destinations that are served by those hubs (without duplication)



Can you help me please?