Reporting Records that Don't Contain Records In the Body's Table
I'm having a slight issue with my reports.
I am still working on a property inventory solution.
My report is based on the 'Room Inventory' table.
This has a leading summary part based on a field within the 'Room Inventory' table.
Above that is another leading summary part based on the 'Rooms' table.
There is also a trailing part that shows photos for that paticular room, based on the 'Photos' table.
The problem I'm having is that within some reports, the user doesn't need to create any records within the 'Room Inventory' table but the report still needs to show that room with it's photos. If there's no records within that room though, the room doesn't show at all.
Some rooms will have 'Room Inventory' Records and some won't, is there any way of making the report show all rooms regardless of if they have records in the 'Room Inventory' table?