Context: I’m working on a project that has a number of active/inactive flags.
There is a list of user-defined amenities and each of the amenities needs to have an amenity type allocated to it.
The amenity type is a dropdown list (present on the add amenity form) ideally should only contain the active amenity types. At the moment, the amenity type drop-down contains all the amenities stores in the DB irrespective of the active/inactive flag.
How can I resolve this?