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