Is there a way to do this when just showing the first row not is the
answer. The relationship have to count values from all the related
records, but must not show more than one occurence for each customer.

FM 7.03-8, Win/Mac.

Rgds Helge Hafstad

In article <1h6vy5r.10erv05fngy02N%helgehd (AT) start (DOT) no>, helgehd (AT) start (DOT) no
says...
No way to "filter" a portal. If that's really the behaviour you are
looking for consider modifying your relationship by adding a new table:

e.g.

Instead of Parent -> Child

Make it

Parent -> CustomerFilter -> Child

Adding this intermediate stage that relates through a customer record...
it might simply have 2 fields: ParentID, CustomerID

And where child records used to have ParentID, they now need to relate
on a composite ParentID/CustomerID.

This will make creating/deleting child records more complex, but will
allow you to create portals with the filter behaviour you asked for.

-regards,
Dave