Hi,

I have a nice design that precludes the use of lists and sub summaries, I think??

Problem is i have a table that records through a portal:

Bldgs/Floors/Rooms/No of windows/No of lights ...

and on a different tab (same layout) I want to display:

Bldgs/Floors/No of windows (summarised)/No of lights (summarised)

But so far I'm getting repeats of Bldgs and Floors where there are multple rooms for each floor.

Any ideas how to summarise this without the repeats? I've considered updating a seperate table using just Bldgs/Floors/Windows/Lights etc.

Any ideas???

Best regards,

Simon

Make the portal show records from Floors. Define calculation fields in the Floors table to provide the totals, or use summary fields from the Rooms table.

Problem is i have a table that records through a portal

Genuine summaries won't show properly in portals, use a list view for that, or seek shelter under Ugo's method - which Fenton shows here:

http://fmforums.com/forum/showpost.php?post/266487/

...but beware it puts greater stain on the kettles than genuine subsummary reports:

...while the movie is made in the fm9 haydays, could the Preview today be avoided with the new...

--sd

Genuine summaries won't show properly in portals

You'd be surprised.

thanks 'consultant' works well

Regards,

Simon