How do I display query results from joined tables (using D..

A bit of a newbie question

How do I display results from Joined tables?

[Ships Table]
ShipID
ShipName

[Voyages Table]
VoyageID
ShipID - Foreign Key(Ships Table)
VoyageName
DepartureDate
ArrivalDate

[Passengers Table]
PassengerID
VoyageID - Foreign Key(Voyages Table)
PassengerName

I wish to run a query (search) on the passengers table (by PassengerName)
and return a recordset displaying
PassengerName, ArrivalDate (Voyages Table), VoyageName (Voyages Table),
ShipName (Ships Table)

The above Tables are linked with One to Many Relationships

I understand I use the join method in a query but what (and how) can I use
to display the (DAO) result - DBgrid, MSFlexGrid ?

I am using VB6 with Access2000

Ah! figured it out!


Thanks anyway


"Peter M" <pmarquet DeleteThis @ihug.co.nz> wrote in message
news:zmytc.11088$XI4.399112@news.xtra.co.nz...
 > A bit of a newbie question
 >
 > How do I display results from Joined tables?
 >
 > [Ships Table]
 > ShipID
 > ShipName
 >
 > [Voyages Table]
 > VoyageID
 > ShipID - Foreign Key(Ships Table)
 > VoyageName
 > DepartureDate
 > ArrivalDate
 >
 > [Passengers Table]
 > PassengerID
 > VoyageID - Foreign Key(Voyages Table)
 > PassengerName
 >
 > I wish to run a query (search) on the passengers table (by PassengerName)
 > and return a recordset displaying
 > PassengerName, ArrivalDate (Voyages Table), VoyageName (Voyages Table),
 > ShipName (Ships Table)
 >
 > The above Tables are linked with One to Many Relationships
 >
 > I understand I use the join method in a query but what (and how) can I use
 > to display the (DAO) result - DBgrid, MSFlexGrid ?
 >
 > I am using VB6 with Access2000
 >
 ><!-- ~MESSAGE_AFTER~ -->