Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DB design / Query help (A2K)

    I need some help please to design a database that is a tariff and upon which I can calculate quotes.

    I receive rates from dozens of airlines that carry cargo for me, these are given in weight breaks such as Minimum $100.00
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: DB design / Query help (A2K)

    Steve,

    I think you need 2 tables. The first is the DestinationCharge table which is comprised of: Airline, Destination, FSC, SSC, AwbFee.

    The 2nd table would be a child table to the first table, and would record each weight range as a separate record, with these fields: Airline, Destination, Weight, Rate.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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