How to display a list of facilities with an active record
I have a database used for keeping records of rental equipment. When a new record is created, a facility is assigned to the record. When an individual piece of rental equipment is discontinued, a status field is changed to inactivate the record. A particular facility may have a few, or a large number of active rentals. What I want to do is to display a list of facilities that have at least one active record. I cannot figure out how to do this, so any help would be appreciated--so thanks in advance to anyone wiling to help me out.