I've two tables related by a room number. one called "room" and the other "equipment in room".

I want a report to list all the rooms with all equipment listed under a "room number" sub-summary. Not all rooms have equipment.

If I make the layout show records from "room layout" I only get one piece of equipment listed and if I make the layout "equipment" I dont see the rooms with no equipment.

Any thoughts? thanks

This is an issue that comes up often with related databases. There is no real way around it other than to create empty records (which I don't particularly like doing).

You could put a portal on the room layout to display the equipment.This is excellent for viewing but portals are sub-optimal for printing.

Alternatively in the Rooms table create a calculate field that uses the List() function to aggregate all related equipment records together in a paragraph delimited list. Then display this calculated field on the report.

This too has its limitations but it's useful.

Thanks Vaughan - I have concatenated a series of fields to make the list function.

Do you know if you can put Tabs in a calculation like you can paragraphs?

It may be possible but it would have to be done in a calculated field on the equipment side.

Yes you can add tabs into a calculation but doesnt seem to be able to set a position (which is needed in this instance).

Wonder if any one is able to offer a way?

The position of tabs is set in Layout mode: select the field (i.e. the final field that displays the result) and choose Format > Text… > Paragraph… > Tabs…

That worked!!! (although was in format> Line spacing>other…> (tab button) thanks guys