Drop Down Contents linked to Contents of Another Field


My table is going to end up as a form. One field is a drop down box listing various resorts. There is another field where I want the form user to be able to select a room category from another drop down list. The room categories will be different for each resort.

I haven’t seen anything in the help files that references this requirement.

Anyone have any suggestions?