Problem with records in a portal
My database has Relationships of:
Clients ----< Policies ----< Renewals
I am trying to have a portal on the Clients layout that shows records from the Renewals table.
The problem I'm having is that 2 of the fields that I need to display in the portal are from the Policies table. Both of these fields will only show information from the first policy record for that Client
Any ideas on how this can be fixed?