AnsweredAssumed Answered

Setting tables up properly

Question asked by JamesPeragine on Feb 12, 2015
Latest reply on Feb 13, 2015 by JamesPeragine


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.