I have classrooms rooms of various capacities, some hold up to 12 people others hold up to 50 and so on. I can put 12 people in a room that holds 50 if all of the 12 people rooms are occupied but I can't put 50 people in room that only holds 12 people.
I have a dependent dropdown box of rooms based on capacity. If you choose a capacity of 12, the room name drop down only shows the rooms that have a listed capacity of 12.
My question is can a dependent dropdown be populated by the control link being a formula like ">= 12"? This way the rooms that hold more than 12 would also be in the room name dropdown because in fact they will hold 12.