Restricting data in 2nd drop-down based on first drop-down
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.