I want to show summary data in a portal.

• the Parent table is "Projects"

• the Child table is "Tasks" - it contains TaskName (e.g. Design, Production, Printing) and TaskAmount (which is a number)

I created a self-join relationship in the Child table to sum the data for TaskAmount and this works fine.

But in the portal in the Parent table I see ALL the related TaskName records (each one showing the correct sum of TaskAmount). Something like this:

Design 1200

Deisgn 1200

Design 1200

Production 250

Production 250

Printing 600

Printing 600

Printing 600

Printing 600

I want to see only ONE of the related records which shows the correct Sum of TaskAmount. Like this:

Design 1200

Production 250

Printing 600

Any ideas would be greatly appreciated.

Cheers, Mike

You could use a custom function for this, or de-dupe the portal using the "Ugo method" - see:

http://fmforums.com/forum/showtopic.php?tid/157638/post/157908/#157908