AnsweredAssumed Answered

How to display a list of facilities with an active record

Question asked by SteveKeiser on May 21, 2013
Latest reply on Jun 19, 2013 by philmodjunk

Title

How to display a list of facilities with an active record

Post

     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.

Outcomes