Relations-problem

  • Thread starter Thread starter vegarduy
  • Start date Start date
V

vegarduy

This is my problem:

My database is a flight-trip database. It contains various data about a
planned flight, e.g. pilot information, routing, fuelplanning etc.

It also contains the fields [DepartureAirportID), [DestinationAirportID],
AlternativeAirport1ID] and [AlternativeAirport2ID].

All of these fields are supposed to be linked to the same table
(tblAirports) by the field [Airport ID], but I can't figure out how to do
it.

I know this is basic, but I still need the help...:)

Vegard
 
vegarduy said:
It also contains the fields [DepartureAirportID),
[DestinationAirportID], AlternativeAirport1ID] and
[AlternativeAirport2ID].

All of these fields are supposed to be linked to the same table
(tblAirports) by the field [Airport ID], but I can't figure out how
to do it.
Click to expand...

Add tblAirports to the relationship window 4 times; then establish the
relationships (1 per table copy)
 
Yes, I've done that but then I can't get the copies of the [tblAirport] to
be included in queries.

What I really want is to be able to make a form with..

Ha-ha! I decided to make a screenshot of a form and post it, but while
designing that form I found out how to solve my problem :)

But thanx anyway!!!
 
You need to create an Airport table listing all airports regardless of
purpose (i.e. Departure, Destination, ect.). This table will have a
AirportID column to uniqely identify each entry. The trip table will than
have multiple columns (Departure, Destination, Atlernate1, Alternate2, etc.)
which will be based on the Airport table
 
Back
Top