7 Replies Latest reply: Nov 6, 2012 12:10 PM by whiteline _ RSS

    JOINING TABLES THROUGH MULTIPLE FIELDS

    Francesco Carmellini

      i don't even know if the title of my question fits...

      i have two tables like these:

       

      Flight N°delay1 codedelay1 timedelay2 codedelay2 timedelay3 codedelay3 timeTOT delay time
      1AA0:15FH1:40MK0:052:00
      2AG
      3FH
      4LL
      5MK

       

      delay codedelay description
      AAlate arrival
      AGstand busy
      FHaircraft damage
      LLheavy weather
      MKtake-off permission denied

       

      so i hav three types of delay (3 possible causes of delay) but only one association for the delay type and its description. of course delay code fields can all be filled as filled in part; the codes that can be used in a field are the ones unused in the precedent field(s). how can i link these two tables? thanx, good halloween