1 Reply Latest reply on Aug 25, 2011 9:03 AM by philmodjunk

    Restricting data in 2nd drop-down based on first drop-down

    ZenOah

      Title

      Restricting data in 2nd drop-down based on first drop-down

      Post

      Hiya,

      I have looked around the forums and seen examples of what sounds like a solution for what I need but haven't seen a legible example of what i'm trying to achieve.

      Essentially through a portal I create hotel records using information from a related hotel table. I want the city field to show only the available cities in the hotel table and then the hotel name field to show only the available hotels in the selected city.

      First screenshot showing city looks correct. Second screenshot shows all the hotels which is wrong.

      I've tried many combinations of value list calculations but none work.

      Any ideas?

       


      Thanks,
      Zen