A nagging problem

  • Thread starter Thread starter Chris Scurrah
  • Start date Start date
C

Chris Scurrah

Hiya guys - thanks in advance for any advice.

I have a huge table setup - geared towards displaying
flight times for our personnel.

These times have the layout "Flight No" "ETA" "ATA" "FROM"
and "TO". There are 3 sets of these timings, headed Inital
Flight, Connecting Flight, To Final Destination.

The table that they are displayed on has the following
layout :-
(Flight No, ETA, ATA, From, To(taken from the "To Final
Destination set)) and (Flight No, ETA, ATA From, To (Taken
from the "Initial Flight" set))

What I am trying to get, is a way of filtering the "To
Final Destination" set, without affecting the initial
flight. For example, If i have a passenger who is flying
from New York to Heathrow, then Heathrow to Glasgow, the
New York - Heathrow leg would show in "Initial Flights",
However I dont want Flights from Heathrow to show in
the "To Final Destination" fields, even though the data
will actually be there.

Is this possible, and how do I go about setting it up?
 
Chris,

I'm not sure how to fix the problem with your existing table structure, but
I would suggest normalizing your data tables. It sounds as if you have two
tables that store the same data fields (Flights). I would suggest a master
detail relationship between Trips and Flights. One table called Trips could
contain a single record with such info as Date, Employee, Origin and
Destination airports. This record could be related to one or many records
in the Flights table which stores both initial and destination flights. To
determine which flight is the destination flight you could simply find
flight where the 'To' airport matches the Destination airport of the related
trip record.

HTH,
Josh
 
Back
Top