7 Replies Latest reply on Jun 19, 2013 9:46 AM by philmodjunk

    How to display a list of facilities with an active record

    SteveKeiser

      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.