Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012

    Unanswered: New Columns from Row Data

    I have a table with rows of flight legs with different passenger names for each leg. Because there can be up to 4-5 passengers on each leg I have a flight leg row for every different passenger name.

    What would be the best method to display each flight leg only once using additional columns (passenger1, passenger 2...) for the passenger data?

    Current Result:

    [Date] [Depart] [Arrive] [Origin] [Destination] [Passenger1]
    [Date] [Depart] [Arrive] [Origin] [Destination] [Passenger2]

    Preferred Result:

    [Date] [Depart] [Arrive] [Origin] [Destination] [Passenger1] [Passenger 2]


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    This is a presentation option, not data storage/integrity/manipulation, so it is best handled on the client side.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts