I'm using a dependent drop down for room and ...

[Tammi_Canelli]

I’m using a dependent drop down for room and cot assignment based on need (i.e. oxygen, set of rooms; memory, set of rooms, etc).

The drop down works great except I can’t figure out how to have the “assigned” cots removed the list of available.

I created a separate table view of “available” cots and the user will be able to click on an action button to mark it unavailable but even though it falls off that list it still shows in the drop down.

Any ideas how to remove from drop down?

I thought about a show if expression but was afraid that was for the entire column not the items within the column if that makes sense.