I want to create a conditional drop down that takes advantage of multi select.
I have three tables: Events, Venues, Rooms
Some Events take place in one Room of a Venue, some Events take place in more than one Room of a Venue. So when users are creating a new Event and choose a Venue I want them to be able to choose multiple Rooms when it's called for. When a user selects a Venue for an Event I want to restrict the Rooms choices to only Rooms in that Venue.
A conditional drop down is much more preferable to a field in the Events tab that is just a multi-select text field called Room(s) and a lot of dynamic form rules.