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

    Find based on a List of Record IDs


      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::__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?