4 Replies Latest reply on Feb 13, 2015 7:44 AM by JamesPeragine

    Setting tables up properly

    JamesPeragine

      Title

      Setting tables up properly

      Post

      I'm setting up my FlightsLegs and I can't figure out how to set up the following

      Table 1 Flights

      Table 2 Airports

      Table 3 Terminals (there are several terminals at each airport that I need to choose from)

      Table 4 (Join Table) Flight Legs

      ____

      In my flights layout I have a FlightLegs portal.  I can add airport and show their related data. I want the user to be able to select which terminal to use after the airport chosen but I can't figur out how to set up the

      1) relationship

      and subsequintly 

      2) value list drop down

      I want it to only show the Terminals that are avaiable at that airport in the drop down box.

       

       

        • 1. Re: Setting tables up properly
          philmodjunk

          Flight----<FlightLeg>----AirPort|Arriving-----<Terminals
                                   v
                                   |
                             ArrTerminal|FlightLeg>-----Airports|Terminal

          The relationship to Terminals lets you present the user with a list of terminals limited to just those found at a particular airport while ArrTerminals|FlightLeg shows the specific Arrival terminal specified for that leg of the person's filght.

          • 2. Re: Setting tables up properly
            JamesPeragine

             Got it

            1) Does the    |   character represent a join table in the diagram?

            2) Do I use the   FlightLeg>----AirPort|Arriving-----<Terminals  relationship for  "Include Only Related Value Starting from" ?

             

            • 3. Re: Setting tables up properly
              philmodjunk

              1) It does not, it's just part of the name of a table occurrence "box" in Manage|database|relationships

              2) That is certainly the most typical option and a good choice for what should be a pretty short list of options. Terminals would be your source of values and FlightLeg would be your "starting from" table occurrence.

               

              • 4. Re: Setting tables up properly
                JamesPeragine

                Okay got it

                AirPort|Arriving     (Is this a TO of Aiports?)

                ArrTerminal|FlightLeg     (Is this also a TO of Airports?)

                Airports|Terminal     (Is this a TO of Terminals?)