That would require basing your layout on the Rooms table instead of the Room Inventory table. The table occurrence name (box in Manage | Database | Relationships), that you select in Layout Setup... | Show Records From is what controls which table your layout is based on. When you change tables here, all your fields typically need to be udpated to match, so you may find it easier to start over with a new layout based on the other table.
If I base the layout on the 'Rooms table', will it still show all 'Room Inventory' items if present though?
What you are asking for, Matthew, is a left outer join (meaning that you want the details from the child table but to also include parent records even if no children.
I assisted Andy Walters with a solution in which he posted his results here:
This shows using virtual technique to write records to another table (star join) achieve what you wish; even if multi-user. This technique works when bringing together more than one table into one report where 'both sides' must have all records included.
Thanks LaRetta, I'll have a look at this when I get a chance and will let you know how I get on.
Ok, I've finally had a chance to look at the sample file for the left outer join and it's gone way over my head!!
I've attached a picture of a couple of pages from a typical report produced within my solution.
The 2 tables in question here are 'Rooms' and 'Room Inventory'. Above the body is a leading sub summary part based on the table 'Rooms' that shows the name of the room. The body of the report is base on the 'Room Inventory' table, this shows the particular room's inventory items (The page with the blue column down the left hand side). The next page is a trailing sub summary part based on the 'Rooms' table which shows photos of the room.
I dont even know where to start with this left outer join to get the same results as my current report, any help?