5 Replies Latest reply on Jan 30, 2012 1:22 AM by james.gould

    Find based on a List of Record IDs

    james.gould

      We have built a solution for collecting data that is then being fed into a room booking system.

       

      (Some of) the tables are as follows:

       

      [Building]----[Floor]----[Room]

       

      Where:

      (Building::__id = Floor::_id_Building)

      (Floor::__id = Room::_id_Floor)

       

      My problem is that now I've been asked to export the records for a specific building... Exporting the building and the floors isn't a problem, a simple find to Building::__id and Floor::_id_Building does the trick nicely. However once I a down to the Room table (and other tables that are related to the room table) I have no easy way of finding all the Rooms that belong to a given building.

       

      Ideally I would like to find Rooms where the Room::_id_Floor belongs to a list that I can populate using a calc [e.g. Building::%floorIdList = List ( Floor::__id ) ]...

       

      What is the best way to acheive this? Find using a value list? Go to Related Record [Display Only Related Records] or something I haven't thought of yet?

       

      Thanks,

      James.