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

    Setting tables up properly



      Setting tables up properly


      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


          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

             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

              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

                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?)