I have a DB that contains Customers, Rooms and the Cabinets you want. One customer has many rooms and the cabinets from one room has many. Easy enough. But when I create a RoomID for a grouping for a report that has customer info in the report header, RoomID as a GroupHdr with all of the room...