Each Portal row shows a repeat of only the first record's data
Having a strange problem with a portal. Have a table of UPS billing detail. This table has CustID and InvID fields.
On my Invoices Table I have 2 portals where I want to show this UPS billing detail. One shows all UPS records for this invoiceID, and it works perfectly and shows the 6 different records for this invoice.
I duplicated the portal, and duplicated the relationship, then changed the relation to "CustID = CustID", to show all the UPS records for that customer. The new portal shows the same record 21 times. There are 21 records with that CustID so the record count is correct, but each record repeats with ONLY the 1st record's data.
Can anyone suggest what causes an error where it populates each portal row with the data from the first record?